Rendimiento - Tiempos_db_file_sequential_read

Script para el análisis de tiempos en milisegundos del evento de espera db_file_sequential_read, indicador clave del rendimiento del subsistema de E/S, basado en las estadísticas de AWR

column c2 format 999.99
PROMPT Usage: tiempos_db_file_sequential_read.sql HORA
PROMPT Donde HORA= 08, 09, ...
select   TO_CHAR(a.end_interval_time,'DAY') DIA,
     a.end_interval_time "Fecha",
   sum(b.time_waited_micro-c.time_waited_micro)/sum(b.total_waits-c.total_waits)/1000 c2
from
   dba_hist_snapshot a,
   dba_hist_system_event b,
   dba_hist_system_event c
where
    a.snap_id=b.snap_id and
    a.snap_id=c.snap_id-1 and
    a.end_interval_time like '% &&1:%' and
   b.event_name = 'db file sequential read' and
   c.event_name = 'db file sequential read' and
   TO_CHAR(a.end_interval_time,'DAY') not LIKE 'SÁBADO%' AND
   TO_CHAR(a.end_interval_time,'DAY') not LIKE 'DOMINGO%'
group by
    a.end_interval_time,
       TO_CHAR(a.end_interval_time,'DAY')
order by
    a.end_interval_time;