-- name       : sys_event.sql
-- date       : 14-Nov-2001
-- Author     : Pentest Limited
-- Description: Show the system event statistics
-- limitation : needs access to v$system_event
--
-- useage     : SQL> @sys_event

set pages 50
set feed off
set verify off
set linesize 200

spool sys_event.lis

col event for a30
col total_waits for 999,999
col total_timeouts for 999,999
col time_waited for 999,999
col average_time for 999,999

select 	event event,
	total_waits total_waits,
	total_timeouts total_timeouts,
	time_waited time_waited,
	average_wait average_wait
from v$system_event
/

spool off

set pages 24
set feed on
set verify on
set lines 80