Blame
| 4726f2 | feagor | 2025-12-02 11:57:21 | 1 | # ASH - Average Active Session(AAS) |
| 9108a6 | feagor | 2025-12-02 10:34:22 | 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 | ``` |