My Oracle Support Banner

Performance Problem Searching some Secured Sources (Doc ID 468656.1)

Last updated on FEBRUARY 02, 2024

Applies to:

Oracle Secure Enterprise Search - Version to
Information in this document applies to any platform.


Using Secure Enterprise Search 10.1.8, under some cases simple queries last more than half an hour.
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:

To Reproduce:

  1. Enable the Identity Plug that you will use for user identity retrieval and ACL construction.
  2. Create your source.
  3. Search normal documents and see how long it takes the search application to respond.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.