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 MARCH 08, 2017

Applies to:

Oracle Internet Directory - Version 11.1.1.7.0 and later
Portal - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

Oracle Internet Directory (OID) 11g 11.1.1.7.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:

SELECT ATTRVALUE, NVL(ATTRTYPE, ' ')
FROM CT_UNIQUEMEMBER
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.


Cause

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