Skip to Main Content
Forums

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 -- How to find object from handle address

735564Nov 18 2009 — edited Nov 18 2009
Oracle Version 10.2.0.3 Linux

We are experiencing "library cache lock" wait event on a simple select statement going against one table. The table definiton is not being modified. It is mystery why "library cache lock" is happeing. From the dba_hist_active_session_history, I can find the following:

P1TEXT P1 P2TEXT P2 P3TEXT P3
handle address 14442556872 lock address 12757752736 100*mode+namespace 301


There is no blocking session but the BLOCKING_SESSION_STATUS is shown as GLOBAL.

How do I troubleshoot this issue further?

How can I get the object name from handle address?

Thanks a lot.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 16 2009
Added on Nov 18 2009
#general-database-discussions
3 comments
3,121 views