Dear All,

When I fired select for update from one session then I am getting differnt ROW_WAIT_OBJ# & ROW_WAIT_FILE#.
Can some one explain me why I am getting different objectid in v$session?


Below are the details for same:

From session one fired for update on table TESTCASE, whose object_id=32997.
If checked in v4locked_object it's showing me correct object_id.
When i looked into v$session to generate rowid it's showing me different objectid.

Session 1:  select * from TESTCASE where FOD_ORDR_RFRNC='200902241100000150' for update; 

Session 2: 

select owner,object_name,object_id,object_type from dba_objects where object_name='TESTCASE';

OWNER                          OBJECT_NAME                     OBJECT_ID OBJECT_TYPE
------------------------------ ------------------------------ ---------- -------------------
SYS                            TESTCASE		                   32997 TABLE

SQL>  select * from v$locked_object;

    XIDUSN    XIDSLOT     XIDSQN  OBJECT_ID SESSION_ID ORACLE_USERNAME                OS_USER_NAME                   PROCESS      LOCKED_MODE
---------- ---------- ---------- ---------- ---------- ------------------------------ ------------------------------ ------------ -----------
        10          5      63030      32997       2190 SYS                            ora10g                         6582324                3

SQL>  select row_wait_obj#, row_wait_file#, row_wait_block#, row_wait_row# from v$session where sid=2565;

ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW#
------------- -------------- --------------- -------------
           37              1           61766             0


SQL> select object_name from dba_objects where object_id=37;

OBJECT_NAME
--------------------------------------------------------------------------------------------------------------------------------
I_OBJ2

SQL> select table_name,owner from dba_indexes where index_name='I_OBJ2';

TABLE_NAME                     OWNER
------------------------------ ------------------------------
OBJ$                           SYS



Thanks in advance.

Yes, it's showing me WAITED SHORT TIME. 
Van you please explain meaning of "WAITED SHORT TIME".

       SID    SERIAL# STATUS   STATE
---------- ---------- -------- -------------------
      2293        185 ACTIVE   WAITED SHORT TIME

From one session i am getting following output.

SQL> select row_wait_obj#, row_wait_file#, row_wait_block#, row_wait_row#,state from v$session where sid=2565;

ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# STATE
------------- -------------- --------------- ------------- -------------------
           -1              0               0             0 WAITING


Here state is waiting, but showing ROW_WAIT_OBJ# is -1.