两种查看行锁方法的对比

SQL> select WAITING_SESSION,HOLDING_SESSION from dba_waiters;

WAITING_SESSION HOLDING_SESSION
--------------- ---------------
             43              41

SQL> /

WAITING_SESSION HOLDING_SESSION
--------------- ---------------
             51              41
             48              41
             43              41
             51              43
             48              43
             43              43
             51              48
             48              48
             43              48

9 rows selected.

SQL> with lk as (select blocking_instance||'.'||blocking_session blocker, inst_id||'.'||sid waiter 
  2                    from gv$session 
  3                    where blocking_instance is not null 
  4                      and blocking_session is not null)
  5        select lpad('  ',2*(level-1))||waiter lock_tree from
  6         (select * from lk
  7          union all
  8          select distinct 'root', blocker from lk
  9          where blocker not in (select waiter from lk))
 10        connect by prior waiter=blocker start with blocker='root';

LOCK_TREE
--------------------------------------------------------------------------------
1.41
  1.43
  1.48
  1.51