Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: what row_wait_obj#, row_wait_file#, row_wait_block#

Re: what row_wait_obj#, row_wait_file#, row_wait_block#

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 24 Jun 2006 13:59:52 -0700
Message-ID: <1151182792.341302.174480@p79g2000cwp.googlegroups.com>

Jonathan Lewis wrote:
> <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
>

N, in the past if the v$session.lockwait column is null then it means that the session is NOT currently waiting on a lock. When the lockwaited column is not null is when a problem exists as the session is waiting.

In the past you would have expected the row_wait_x columns to be null when the lockwait column was null and perhaps to have values when it was non-null. Now, at least according to the 0gR2 Reference manual Oracle lists the blocking session in v$session.blocking_session. (time to rewrite lock blocking scripts)

HTH -- Mark D Powell -- Received on Sat Jun 24 2006 - 15:59:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US