两种查看行锁方法的对比

SQL> select WAITING_SESSION,HOLDING_SESSION from dba_waiters;WAITING_SESSION HOLDING_SESSION--------------- ---------------             43              41SQL> /WAITING_SESSION HOLDING_SESSION--------------- ---------------             51              41             48              41             43              41             51              43             48              43             43              43             51              48             48              48             43              489 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