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;``` |