Oracle System Events Monitor
Displays wait event statistics at the system level, including total waits, timeouts, average wait time, and total time waited. Useful for performance monitoring and identifying system-wide bottlenecks.
oraclesqlperformance-tuningv1.0.0
0 stars0 downloads15 views0 comments
By OracleDba • Created
Code
(16 lines)12345678910111213141516
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/system_events.sql
-- Author : Tim Hall
-- Description : Displays information on all system events.
-- Requirements : Access to the V$ views.
-- Call Syntax : @system_events
-- Last Modified: 21-FEB-2005
-- -----------------------------------------------------------------------------------
SELECT event,
total_waits,
total_timeouts,
time_waited,
average_wait,
time_waited_micro
FROM v$system_event
ORDER BY event;