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 MAY 06, 2021
Applies to:Oracle Internet Directory - Version 184.108.40.206.0 and later
Portal - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
Oracle Internet Directory (OID) 11g 18.104.22.168.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