After Upgrading To 11.1.1.9, DB Shows SQL Query Consuming High Disk I/O
(Doc ID 2275824.1)
Last updated on NOVEMBER 01, 2022
Applies to:
Oracle Internet Directory - Version 11.1.1.9.0 and laterInformation 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
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
Symptoms |
Cause |
Solution |
References |