--
--  Name: system_event_show.sql
--
--  Description: system events - Displays the non-idle system events for the database
--
--  Compatability: 7.3.x and above
--
--  Usage: @system_event_show
--
-- 
set lines 150
select * from v$system_event
where 
NOT(event like 'SQL%') 
and 	NOT(event like '%message%') 
and 	NOT(event like '%timer%') 
and 	NOT(event like '%pipe get%') 
and   not(event like 'slave wait')
order by time_waited
;