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
Last updated on MARCH 08, 2017
Applies to:Oracle Internet Directory - Version 220.127.116.11.0 and later
Portal - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Oracle Internet Directory (OID) 11g 22.214.171.124.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.
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