000031852 - High Response times observed in RSA Adaptive Authentication (OnPrem) 7.1 P2

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000031852
Applies ToRSA Product Set: Adaptive Authentication (OnPrem)
RSA Version/Condition: 7.1 P2
Platform: UNIX
IssueHigh Response times are observed in RSA Adaptive Authentication (OnPrem) 7.1 P2.
CauseThis 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 (?, ?, ?, ?, ?, ?, ?, ?, ?)
ResolutionTo 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.
 
    UPDATE 
  &lt;core.db.schema&gt;.re_hints
SET
  query_desc = &#39;PROFILE_SQL_SELECT_HINT&#39;,
  HINT = &#39;/*+ NUM_INDEX_KEYS(@&quot;SEL$1&quot; &quot;RE_PROFILE_FACTS&quot;@&quot;SEL$1&quot; &quot;PK_RE_PROFILE_FACTS&quot; 2) */&#39;,
  LAST_UPDATE = SYSDATE
WHERE
  query_id = &#39;hint_oracle_online_select_profile&#39;;
COMMIT;

 

Attachments

    Outcomes