4 . Which row is locked? 
======================= 
 
Session  11  has a TM lock on object  4933  (Table SCOTT.DEPT), but most of the time applications update several tables and might not be very clear in the detail window what object has the lock.  
To be more certain, the following queries show the info : 
 
  select sid,ROW_WAIT_FILE#,ROW_WAIT_BLOCK#,ROW_WAIT_ROW# 
  from v$session where sid = 11 ; 
 
 SID ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# 
 ---- ------------- -------------- --------------- ------------- 
 
   11            4933               11              1022              13   
 
  select object_type,owner,object_name 
  from dba_objects 
  where object_id= 4933 ; 
 
OBJECT_TYPE        OWNER   OBJECT_NAME 
 ------------------ ------- ----------- 
 
TABLE              SCOTT   DEPT 
 
  SELECT * FROM EMP WHERE rowid =  
  DBMS_ROWID.ROWID_CREATE( 1 ,  4933 ,  11 ,  1022 ,  13 ); 
 
EMPNO ENAME    JOB    MGR   HIREDATE  SAL       COMM     DEPTNO 
 ----- -------- ------ ----- --------- --------- -------- ---------- 
 
  7934  MILLER   CLERK   7782    23 -JAN- 82   1430                 10  
 
 
The File#,block#,row# give us up to what row is currently waiting but it does not tell us if it will be waiting for more after this lock is cleared even with this same sql statement.