Performance Problem Searching some Secured Sources
Last updated on DECEMBER 05, 2016
Applies to:Oracle Secure Enterprise Search - Version: 10.1.8.0 to 10.1.8.2
Information in this document applies to any platform.
SES is using secured sources that use an Identity Plug in to get the ACL created.
This issue has been reproduced using Active Directory and Lotus Notes Identity Plugins.
The SQL statements have been traced for the slow database session and found the expensive SQL statement is:
select /*+ FIRST_ROW(1) */ nvl(MAP_ID, '0')
from EQ_TEST.EQ$SEC_ATTR_VAL where SATTR_ID = :1 and VAL = :2 and rownum <= 1
Enable the Identity Plug that you will use for user identity retrieval and ACL construction.
- Create your source.
- Search normal documents and see how long it takes the search application to respond.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms