This information can be obtained by querying v$lock.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Jano" <402450_at_cepsz.unizar.es> wrote in message
news:5d6fdb61.0203190538.70b192f5_at_posting.google.com...
> Hello all.
>
> I'm using user locks (package dbms_lock). The locks are created with
> automatic release on rollback or commit.
>
> Now, I'm having some problems because some session has the lock and I
> don't know what is it. I fear that some point of the code has a
> missing commit. To try to isolate the problem I want to know what is
> the session with the lock acquired.
>
> How can I know what session has the lock?
>
> Thanks in advance,
>
> A. Mosteo.
>
> P.s: if you can CC: to my account (402450_at_cepsz.unizar.es) it will be
> useful, because I can't spend much time in the news.
Received on Tue Mar 19 2002 - 07:57:12 CST
