After Upgrading To 11.1.1.9, DB Shows SQL Query Consuming High Disk I/O (Doc ID 2275824.1)

Last updated on AUGUST 29, 2017

Applies to:

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

Symptoms

After upgrading to 11.1.1.9, DB shows below SQL query consuming high Disk I/O. Each execution taking around 907 secs

SELECT /*+
USE_NL(store) INDE:@store EI_ATTRSTORE) INDE:@dn RP_DN) LEADING(dn) */
store.entryid, store.attrname, NVL(store.attrval,' '), NVL(store.attrstype, ' ') , attrkind,NVL(store.AttrVer,' ')
FROM
ct_dn dn, ds_attrstore store
WHERE
(dn.parentdn like :bdn ESCAPE '\' OR (dn.rdn = :rdn AND dn.parentdn = :Pdn))
AND
dn.entryid >= :entryThreshold AND dn.entryid = store.entryid AND store.attrkind IN ('u','o','t') order bystore.entryid

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