After Upgrading To, DB Shows SQL Query Consuming High Disk I/O

(Doc ID 2275824.1)

Last updated on OCTOBER 26, 2017

Applies to:

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


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

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,' ')
ct_dn dn, ds_attrstore store
(dn.parentdn like :bdn ESCAPE '\' OR (dn.rdn = :rdn AND dn.parentdn = :Pdn))
dn.entryid >= :entryThreshold AND dn.entryid = store.entryid AND store.attrkind IN ('u','o','t') order bystore.entryid


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