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:
Post a Comment