set echo off
set feedback off
set linesize 512

prompt --------------------------------
prompt - Liste des evenements systeme -
prompt --------------------------------

column event format a32

column total_waits     format	999,999,999,999 heading "Total Attentes"
column total_timeouts  format	999,999,999,999 heading "Total Timeouts"
column time_waited     format	999,999,999,999 heading "Temps attendu"
column average_wait    format	999,999,999,999 heading "Moyenne d'attente"

SELECT	 
   EVENT EVENEMENT, 
   TOTAL_WAITS, 
   TOTAL_TIMEOUTS, 
   TIME_WAITED, 
   AVERAGE_WAIT
FROM 
   V$SYSTEM_EVENT
ORDER BY 
  4 DESC;
