Re: definition of v$session

From: Mark D Powell <markp7832_at_my-deja.com>
Date: 2000/04/28
Message-ID: <8ec629$s77$1@nnrp1.deja.com>#1/1

In article <3908b129.6262068_at_news.remarq.com>, dcowles_at_i84.net (Doug Cowles) wrote:
> Can someone help me out with what these columns mean
> in v$session?
>
> ROW_WAIT_OBJ# NUMBER
> ROW_WAIT_FILE# NUMBER
> ROW_WAIT_BLOCK# NUMBER
> ROW_WAIT_ROW# NUMBER
>
> I've understood from previous posts that determing what row a lock is
> really on is very difficult and may require a block dump, which is why
> I am confused by these columns... Any documentation reference with
> part no# appreciated as well.
>
> Thanks,
> DC.
>

These columns are the rowid of the row that a waiting session is waiting on when the wait is caused by a row level lock. Not all lockwaited conditions are caused by row level locks.

Here are some sample sql's since a lock just happens to exist on my system righ now:

select sid, username,

         row_wait_obj#,
         row_wait_file#,
         row_wait_block#,
         row_wait_row#
from     v$session

where row_wait_obj# != -1
order by row_wait_file#, row_wait_block#, row_wait_row# /

SID USERNAME ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ---------- ------------ ------------- -------------- --------------- ROW_WAIT_ROW#

       118 SDUTKI01              2244            132           84223
           19

       152 GKELLY01              2244            132           84223
           19

You can tie the row_wait_obj# to sys.dba_objects and the file# to sys.dba_datafiles or v$datafile.

Enter value for objectid: 2244

OWNER        OBJECT_NAME                    OBJECT_TYPE  STATUS
------------ ------------------------------ ------------ -------
WAR          R53_CLAIM                      TABLE        VALID

I haven't yet written the code to locate the actual row via these columns, but maybe someone else has and will post it.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Fri Apr 28 2000 - 00:00:00 CDT