Oracle - What statements are performing full scans (https://app.pluralsight.com/library/courses/oracle-performance-tuning-developers/table-of-contents)

full_scans.sql

select pl.object_owner, pl.object_name,
    pl.sql_id, q.sql_text, q.module,
    pl.operation, pl.options, pl.cost, pl.cpu_cost, pl.io_cost,
    q.executions
from v$sql_plan pl, v$sql q
where pl.sql_id = q.sql_id
and ((pl.operation = 'TABLE ACCESS' and pl.options = 'FULL')
or (pl.operation = 'INDEX' and pl.options = 'FAST FULL SCAN')
or (pl.operation = 'INDEX' and pl.options = 'FULL SCAN (MIN/MAX)')
or (pl.operation = 'INDEX' and pl.options = 'FULL SCAN'))
order by pl.object_owner, pl.object_name;