Re: inconsistent lock info in v$session ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 23 Mar 2005 16:56:40 +0000 (UTC)
Message-ID: <d1s748$9r7$1@titan.btinternet.com>

Depends on your version of Oracle, but v$session changed some time ago to record the last wait of for an object - including such things as buffer busy waits - and doesn't clear the wait values.

Chances are that if you see row_wait_obj_row# is zero when the others are non-zero, the session is showing you a historical wait of something other than a row lock wait.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated March 9th 2005






"ibodogan" <idogan_tech_at_yahoo.com> wrote in message 
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.

>

Received on Wed Mar 23 2005 - 10:56:40 CST