RE: object with library cache lock involved

From: Lim, Binley <Binley.Lim_at_NBNZ.CO.NZ>
Date: Tue, 2 Mar 2004 11:40:15 +1300
Message-ID: <5FA85DB5FB07D7118CF50002A5754C0902E2CA01@nbnzhexch2.nbnz.co.nz>

View DBA_DDL_LOCKS may provide more info?

> -----Original Message-----
> From: Jeroen van Sluisdam [SMTP:jeroen.van.sluisdam_at_vrijuit.nl]
> Sent: Monday, March 01, 2004 10:19 PM
> To: 'oracle-l_at_freelists.org'
> Subject: 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
>

This communication is confidential and may contain privileged material. If you are not the intended recipient you must not use, disclose, copy or retain it. If you have received it in error please immediately notify me by return email and delete the emails.
Thank you.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
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 - 16:37:42 CST