object with library cache lock involved
- From: Jeroen van Sluisdam <jeroen.van.sluisdam@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 1 Mar 2004 10:18:57 +0100
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
Other related posts:
