DBA AWR CPU Load (active session history)

select
xxen_util.client_time(dhash.sample_time_) sample_time,
dhash.instance_number,
dhash.sessions,
xxen_util.zero_to_null(dhash.cpu_sessions) cpu_sessions,
xxen_util.zero_to_null(dhash.waiting_sessions) waiting_sessions
from
(
select distinct
cast(dhash.sample_time as date) sample_time_,
dhash.instance_number,
count(*) over (partition by dhash.sample_id) sessions,
count(decode(dhash.session_state,'ON CPU',1)) over (partition by dhash.sample_id) cpu_sessions,
count(decode(dhash.session_state,'WAITING',1)) over (partition by dhash.sample_id) waiting_sessions
from
dba_hist_active_sess_history dhash
where
1=1
) dhash
where
2=2
order by
sample_time,
instance_number

select xxen_util.client_time(dhash.sample_time_) sample_time, dhash.instance_number, dhash.sessions, xxen_util.zero_to_null(dhash.cpu_sessions) cpu_sessions, xxen_util.zero_to_null(dhash.waiting_sessions) waiting_sessions from ( select distinct cast(dhash.sample_time as date) sample_time_, dhash.instance_number, count(*) over (partition by dhash.sample_id) sessions, count(decode(dhash.session_state,'ON CPU',1)) over (partition by dhash.sample_id) cpu_sessions, count(decode(dhash.session_state,'WAITING',1)) over (partition by dhash.sample_id) waiting_sessions from dba_hist_active_sess_history dhash where 1=1 ) dhash where 2=2 order by sample_time, instance_number