抓跑得慢的SQL，查看正在跑的sql的等待事件

select (sysdate-a.logon_time)*24*60 minutes,
       a.username,
       a.BLOCKING_INSTANCE,
       a.BLOCKING_SESSION,
       a.program,
       a.machine,
       a.osuser,
       a.status,
       a.sid,
       a.serial#,
       a.event,
       a.p1,
       a.p2,
       a.p3,
       a.sql_id,
       a.sql_child_number,
       b.sql_text
  from v$session a, v$sql b
 where
   a.sql_address = b.address
   and a.sql_hash_value = b.hash_value
   and a.sql_child_number=b.child_number
   and a.event not in ('SQL*Net message from client','Space Manager: slave idle wait')
  -- and a.username like '%USERNAME%' 
   order by 1 desc;

在查执行计划

Select * from table(dbms_xplan.display_cursor('91prd0dh0bs8d',0,'ALL'));