ASH Report Generation

We can generate ASH report for SQL_ID using view.

select * from table(dbms_workload_reposiotry.ash_global_report_html(<DBID>,<INSTANCE_NUMBER>,<BEGIN_TIME>,<END_TIME>,<SQL_ID>));

Example:

select * from table(dbms_workload_reposiotry.ash_global_report_html(123455678,1,'07/15/2020 13:02:00','07/15/2020 14:03:00', l_sql_id=>'23ghb7ughtu'));