My Oracle Support Banner

After Upgrading Database 11gR2 for OID 11g, e.g. from to, Oracle (Database) Processes CPU Utilization is 100%, and Unable to Authenticate via OID (Doc ID 2083655.1)

Last updated on AUGUST 29, 2019

Applies to:

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


Oracle Internet Directory (OID) 11g.

OID and its database run on the same server.

Since upgrading the database server, e.g., from to, at first Portal and OID worked normally.

Suddenly, got maxed out CPU utilization errors from (oracle) database processes, and no longer able to authenticate using OID.

Database report shows the following SQL as CPU + Wait for CPU 99.73 activity:

SELECT /*+ USE_NL(store) INDEX(store EI_ATTRSTORE) INDEX(dn EP_DN) FIRST_ROWS */ /* SUBSTRING */ store.entryid, store.attrname, NVL(store.attrval, ' '), NVL(store.attrstype, ' ') FROM ct_dn dn, ds_attrstore store WHERE dn.entryid in ((SELECT /*+ INDEX(at1 VA_myattr) FIRST_ROWS */ at1.entryid FROM ct_myattr at1 WHERE ( at1.attrvalue like :4 ESCAPE '\' ) ) UNION (SELECT /*+ INDEX(at1 VA_objectclass) */ at1.entryid FROM ct_objectclass at1 WHERE at1.attrvalue = 'referral' ) ) AND ( dn.parentdn like :bdn ESCAPE '\' OR (dn.rdn = :rdn and dn.parentdn = :pdn) ) AND dn.entryid = store.entryid AND dn.entryid >= :entryThreshold AND store.attrkind = 'u' AND store.attrname in ( 'orclentrydn', 'objectclass', 'orclentrylevelaci', 'orclownerguid', 'orclresourceviewers', 'owner', 'orclisvisible', :an0, :an1, :an2, :an3 )

OID high level debugged logs do not show errors per se, but show some searches taking a long time to complete with high "DB Fetch" times, for example:

2015-11-04T09:12:26 * Exit gslfseADoSearch
2015-11-04T09:12:26 *
BASE DN = cn=users,dc=<COMPANY>,dc=com
FILTER = (myattr=*value*)
REQD ATTRS = uid myattr

EVENT "BER READ " time : 519 micro sec
EVENT "DIME OVRD " time : 2021244932 micro sec
EVENT "PRVGRP CLS " time : 62 micro sec
EVENT "ACPGRP CLS " time : 54 micro sec
EVENT "PRE DIME " time : 227 micro sec
EVENT "DB Fetch " time : 2021243756 micro sec
EVENT "Post Dime " time : 229 micro sec
EVENT "Ber flush " time : 58 micro sec
TOTAL "Operation " time : 2021245434 micro sec

TOTAL "Worker " time : 2021245644 micro sec




Database was upgraded.


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.