Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What's the query to see all the locks a session holds?

Re: What's the query to see all the locks a session holds?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 31 Jul 2002 10:51:30 +1000
Message-ID: <VoG19.48967$Hj3.146714@newsfeeds.bigpond.com> 





Hi Joseph,



V$LOCK contains details of all locks. Joined with SID from (say) v$mystat
will get all locks held by current session.



Cheers



Richard


"Joseph Weinstein" <joe_at_bea.com> wrote in message
news:3D46FD64.6C30D2E8_at_bea.com...


>

> Hi. What's the query I can run on a connection to see all the locks

> it is currently holding?

>

> thanks in advance,

> Joe Weinstein

>

Received on Tue Jul 30 2002 - 19:51:30 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US