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: inconsistent lock info in v$session ?

Re: inconsistent lock info in v$session ?

From: ibodogan <idogan_tech_at_yahoo.com>
Date: 23 Mar 2005 10:37:19 -0800
Message-ID: <1111603039.270734.41260@f14g2000cwb.googlegroups.com>

good point Michel, i saw the doc before but it doesn't say it for row_wait_obj# ..

so i'll go with lockwait column, if it is not null there is blockage..

my script needed to know whether the session is waiting on a table or not, so i didn't wanna hit another v$ to see if there is tran opened by the session...

i.d. Received on Wed Mar 23 2005 - 12:37:19 CST

Original text of this message

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