10g – DBA_ACTIVE_SESS_HISTORY


select a.snap_id , count(*) 
from dba_hist_active_SESS_HISTORY a 
where
a.event= 'db file sequential read'
 AND a.snap_id >= 1 -- begin snap
 AND a.snap_id <= 700 -- end snap
 group by a.snap_id
 order by snap_id desc; 
 
 
 select a.snap_id , sum(time_waited) 
from dba_hist_active_SESS_HISTORY a 
where
a.event= 'db file sequential read'
 AND a.snap_id >= 1 -- begin snap
 AND a.snap_id <= 700 -- end snap
 group by a.snap_id 
 order by snap_id desc;

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: