Commit 114490
2025-12-02 10:37:34 feagor: -/-| /dev/null .. администрирование oracle/awr&ash/ash - top запросов и их ожидания.md | |
| @@ 0,0 1,13 @@ | |
| + | # ASH - Top запросов и их ожидания |
| + | |
| + | ```oraclesql |
| + | SELECT * FROM ( |
| + | SELECT count(1) cnt,t.sql_id,sql_text,stragg(distinct event) events |
| + | FROM dba_hist_active_sess_history t |
| + | left join gv$sql s on s.SQL_ID = t.sql_id |
| + | 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') |
| + | and t.action like '%293213%' |
| + | group by t.sql_id,sql_text |
| + | order by 1 desc) |
| + | where rownum<=10 |
| + | ``` |