Recent site activity

Oracle IO by FILE


List IO by  FILE#  

 CNT AAS EVENT                   P1 TABLESPACE

---- --- ----------------------- --- ----------

   1 .00 db file sequential read   1 SYSTEM

   2 .00 db file sequential read   3 SYSAUX

  38 .06 db file sequential read   6 SOE

 179 .30 db file sequential read   7 SOEINDEX


col block_type for a18

col objn for a25

col otype for a15

col event for a25

col blockn for 999999

col p1 for 9999

col aas for 999.99

col f_minutes new_value v_minutes

select &minutes f_minutes from dual;

select io.cnt,

       round(io.cnt/(&v_minutes*60),2) aas,

       io.event,

       io.p1 p1,

       f.tablespace_name

from (

       select

              count(*) cnt,

              substr(event,0,25) event,

              ash.p1 p1

       from v$active_session_history ash

       where ( event like 'db file s%' or event like 'direct%' )

          and sample_time > sysdate - &v_minutes/(60*24)

       group by

            event ,

             ash.p1

      ) io,

      dba_data_files f

where

          f.file_id = io.p1

Order by io.cnt

/

Comments