Oracle–查询latch free 等待事件相关信息
--查询latch free 等待事件相关信息
COL event FORMAT a20;
COL waits FORMAT 9999990;
COL timeouts FORMAT 99999990;
COL average FORMAT 99999990;
SELECT event "Event",
time_waited "Total Time",
total_waits "Waits",
average_wait "Average",
total_timeouts "Timeouts"
FROM V$SYSTEM_EVENT
WHERE event = 'latch free'
ORDER BY EVENT;
版权声明:本文为sinat_37436532原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。