Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: inconsistent lock info in v$session ?
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