Oracle Database Discussions

Hi, all.


The oracle version is 10gr2 and snapshot period is 10 minutes.

I would like to count active session in AWR dictioanry with a DETAILED time range, not a snapshot period.

--> average active session count = db time / elapsed time (in 10-minute time range : same as the snapshot period)


Whick awr views could provide the information to count active sesions in a detailed time-range?

"dba_hist_active_sess_history" view could be one of the views?

As far as I know, dba_hist_active_sess_history view contains sampled data, NOT all data.
I am a little confusted.

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

select sample_time,session_type,count(*)
from dba_hist_active_sess_history a
where a.sample_time >= to_date('20111114105000','yyyymmddhh24miss')
and a.sample_time <= to_date('20111114105100','yyyymmddhh24miss')
and a.instance_number=1
group by sample_time,session_type
order by a.sample_time

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

Is the above query meaningful in counting active session at the point of sample time?

If not, which awr views could provide the information to count active sesions in a detailed time-range?


Thanks in advance.
Best Regards.