根据当前等待事件名查找造成该等待事件的SQL

例如查找关于对library ....等待事件有贡献的SQL

select sql_text from V$sqlarea  where (address,hash_value) in

(select sql_address,sql_hash_value from v$session  where event like 'library%');

此语句只能运行于10g版本以上，因为10g中v$session视图包含了等待事件的信息了，9i中没有

1.列出当前系统的等待事件 ：

SQL>SELECT event, sum(decode(wait_time,0,1,0)) "Curr", sum(decode(wait_time,0,0,1)) "Prev", count(*)"Total" FROM v$session_wait GROUP BY event ORDER BY count(*);

2.查看系统的各项等待，按总耗时排序 ：

SQL> SELECT event,total_waits waits,total_timeouts timeouts, time_waited total_time,average_wait avg FROM V$SYSTEM_EVENT ORDER BY 4 DESC;