Home A - Z
Menu

Blame

9108a6 feagor 2025-12-02 10:34:22
1 
# ASH Average Active Session(AAS)
2
3
```oraclesql
4
with t as (
5
SELECT sample_id, snap_id,count(*) aas,
6
sum(decode(session_state,'ON CPU',1,0)) aas_cpu,
7
sum(decode(session_state,'ON CPU',0,1)) aas_noncpu
8
FROM dba_hist_active_sess_history t
9
group by sample_id,snap_id
10
order by sample_id desc
11
)
12
SELECT trunc(begin_interval_time,'dd') "day",
13
max(aas) max_aas,median(aas) avg_aas,
14
max(aas_cpu) max_aasc,median(aas_cpu) avg_aasc,
15
max(aas_noncpu) max_aasnc,median(aas_noncpu) avg_aasnc
16
FROM dba_hist_snapshot h,t where t.snap_id = h.snap_id
17
group by trunc(begin_interval_time,'dd')
18
order by 1;
19
```