|Applies To||RSA Product Set: Adaptive Authentication (OnPrem)|
RSA Version/Condition: 7.1 P2
|Issue||High Response times are observed in RSA Adaptive Authentication (OnPrem) 7.1 P2.|
|Cause||This issue is caused by more gets on an Oracle query, as shown in the example below.|
SELECT /*+ hint_oracle_online_select_profile */ fact_id, value_num, value_str, complex_uri FROM RE_PROFILE_FACTS where PROFILE_URI = ? and COMPLEX_URI IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
|Resolution||To resolve the issue, the user must execute the update statement below to update the hint and restart the application server for this change to take effect.|
Note: Replace <core.db.schema> with the core schema name.