Oracle - What statements consume the most resources (https://app.pluralsight.com/library/courses/oracle-performance-tuning-developers/table-of-contents)

costly_statements.sql

select * from
(
    select sql_id, sql_text, executions,
        elapsed_time, cpu_time, buffer_gets, disk_reads,
        elapsed_time / executions as avg_elapsed_time,
        cpu_time / executions as avg_cpu_time,
        buffer_gets / executions as avg_buffer_gets,
        disk_reads / executions as avg_disk_reads
    from v$sqlstats
    where executions > 0
    order by elapsed_time / executions desc
)
where rownum <= 25;