Home A - Z
Menu
Page Index

Blame

114490 feagor 2025-12-02 10:37:34 1 
# ASH - Top запросов и их ожидания
2
3
```oraclesql
4
SELECT * FROM (
5
SELECT count(1) cnt,t.sql_id,sql_text,stragg(distinct event) events
6
FROM dba_hist_active_sess_history t
7
left join gv$sql s on s.SQL_ID = t.sql_id
8
where t.sample_time between to_date('27.03.2019 18:04:57','dd.mm.yyyy hh24:mi:ss') and to_date('27.03.2019 19:04:17','dd.mm.yyyy hh24:mi:ss')
9
and t.action like '%293213%'
10
group by t.sql_id,sql_text
11
order by 1 desc)
12
where rownum<=10
13
```