Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> object with library cache lock involved
Hi,
I had a strange situation going on:
2 batch scripts seem to be waiting :
- 1 doing an index fast full scan on a table
in v$session_wait this results in a direct path read event
- 1 having a library cache lock in v$session_wait
According to the docs the v$session_wait parameters for the library cache
lock are adresses such as handle_address, but what I want to know in these
cases
is how to get the object involved such that I can point this out to the
developer?
I killed one of the sessions and this solved the progess of the other one. But for next time?
Regards,
Jeroen
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Mar 01 2004 - 03:17:15 CST
![]() |
![]() |