dfs lock handle 诊断

如果当前还在
select chr(bitand(p1,-16777216)/16777215) || chr(bitand(p1, 16711680)/65535) "Lock",
to_char(bitand(p1, 65536)) "Mode",
p2, p3 , seconds_in_wait
from v$session_wait
where event = 'DFS lock handle';

如果不在

select sql_id, session_id, session_serial# serial#, sql_exec_id, sql_exec_start,p1,p2,p3
  from dba_hist_active_sess_history a
 where event = 'DFS lock handle' and sample_time between sysdate-5 and sysdate
 and rownum<11 ;

 select chr(bitand(&&p1,-16777216)/16777215) ||
   chr(bitand(&&p1,16711680)/65535) type,
   mod(&&p1, 16) md
   from dual;

进一步看锁

COL TYPE FOR A8
 COL NAME FOR A30
 COL DESCRIPTION FOR A30
 COL ID1_TAG FOR A20
 COL ID2_TAG FOR A30
select TYPE,NAME,ID1_TAG,ID2_TAG,IS_USER USR, IS_RECYCLE RCY, DESCRIPTION from v$lock_type where type='DX';