Re: inconsistent lock info in v$session ?

"ibodogan" <idogan_tech_at_yahoo.com> wrote in news:1111592043.315452.99570_at_l41g2000cwc.googlegroups.com:

>
> I got some rows in v$session with NULL lockwait column yet they have
> values in all row_wait_* columns ?
>
> if these sessions are waiting on a row then why lockwait column is NULL
> or if they are not waiting, why row_wait_* columns have values ??
>

What happens when a session is waiting for an object which is not locked; such as an enqueue wait? Received on Wed Mar 23 2005 - 09:48:39 CST