Monday, March 4, 2013

Show physical I/O at the data file level


Check the physical I/O at the data file level
break on begin_interval_time skip 2
column begin_interval_time format a25
select
begin_interval_time, filename, phyrds
from
dba_hist_filestatxs
natural join
dba_hist_snapshot;

The AWR also provides  the dba_hist_filestatxs table to track Disk I/O.

No comments: