Re: what row_wait_obj#, row_wait_file#, row_wait_block#

<niy38_at_hotmail.com> wrote in message
news:1151089676.374874.216550_at_c74g2000cwc.googlegroups.com...
> mean where lockwait is null in v$session?
>

Somewhere in 9i, the code changed so that any wait on a block seems to result in the row_wait_x columns being populated (or partially populated) and not being completely cleared down afterwards.

If the lockwait is null, all you can say is that some wait event happened to the object file (and possibly block and row) listed - some time in the recent past.

The wait MAY have been a lock wait (row lock) but it may have been a buffer busy wait, etc.

The manuals have not yet caught up with this change.

-- 
Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

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

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html