Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

library cache lock p1

user13684468May 30 2012 — edited May 30 2012

Can anyone tell me how to find which object was locked via waits "library cache lock" in the past?
If waits were in the morning, and after several hours I want to diagnose these waits, I have ASH report and p1p2p3 values in it.
I tried to execute:

SELECT kglnaown "Owner", kglnaobj "Object" FROM x$kglob WHERE kglhdadr='c0000011fb722038'

but it gave me nothing.
Is there way to find locked object after some time past?
Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2012

Added on May 30 2012

#general-database-discussions

2 comments

401 views