Re: inconsistent lock info in v$session ?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 23 Mar 2005 18:01:40 +0100
Message-ID: <4241a0d6$0$32229$626a14ce@news.free.fr>

"ibodogan" <idogan_tech_at_yahoo.com> a écrit dans le message de 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 ??
|
| i.d.
|

From doc on v$session, about row_wait_* columns: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch3171.htm#1122127 <quote>
...This column is valid only if the session is currently waiting for another transaction to commit...
</quote>

So if session is not waiting, these columns are meaningless.

Regards
Michel Cadot Received on Wed Mar 23 2005 - 11:01:40 CST