Home A - Z
Menu

Blame

ba1d8d feagor 2025-12-02 12:03:47
1 
## ASH - топ запросов генерирующих определенный sql_id
2
3
```oraclesql
4
select t.top_level_sql_id, max(dbms_lob.substr(s.SQL_FULLTEXT, 3500)),
5
count(*) cnt
6
-- ,ses.USERNAME
7
from v$active_session_history t
8
left join v$sql s on s.sql_id = t.top_level_sql_id
9
join v$session ses on ses.SID = t.SESSION_ID and ses.SERIAL# = t.SESSION_SERIAL#
10
where t.sql_id = trim('9rtdzm50px1w4')
11
-- and session_id = 5349
12
group by t.top_level_sql_id
13
--,ses.USERNAME
14
order by cnt desc;```