Oracle: Get slow queries

PHOTO EMBED

Mon Aug 29 2022 19:27:44 GMT+0000 (Coordinated Universal Time)

Saved by @marcopinero #sql

select * from 
( 
    select 
        sql_id, 
        elapsed_time, 
        executions, 
        sql_text 
    from v$sql  
    ORDER BY elapsed_time desc
) 
where rownum < 11;
content_copyCOPY