If you want top 200 sql in your report
dbms_workload_repository.modify_snapshot_settings (topnsql=> 200)
If you want a particular sql even if it’s not in your top list.
dbms_workload_repository.add_colored_sql(:sql_id)
trace one or more sql id
alter session set events ‘sql_trace [sql: sql_id1 |sql_id2]‘
I know about the last one.
convert this post to pdf.