OID 11g with Portal 11g and SSO 10.1.4.3 - Waits on DBMS_LDAP on the Portal DB Affecting Portal Performance with Large Number of Users
(Doc ID 1637036.1)
Last updated on FEBRUARY 15, 2019
Applies to:Oracle Internet Directory - Version 18.104.22.168.0 and later
Portal - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
Oracle Internet Directory (OID) 11g 126.96.36.199.0, integrated with Oracle Portal 11g and Single Sign-On (SSO) 10g 10.1.4.3 recently upgraded from 10g.
Portal suffers from performance issues when a large number of users is active.
On the Portal Database (DB), there are high WAIT_STATES for DBMS_LDAP operations.
Restarting Webcache temporarily resolves the Portal issue.
The following query is the most executed and CPU consuming on the OID system:
WHERE ENTRYID = :entryID AND (ATTRTYPE IS NULL OR ATTRTYPE != 'dgr')
The query seems to perform well, however it is executed many thousands of times on every 10 seconds or less. The query responds very quicky, less than 0.01 seconds per execution, but taking into account the number of executions it has to perform, this may be leading to possible performance problems. Optimizer statistics are current.
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