How to check whether sql query captured in AWR?

How to check whether sql query captured in AWR?

We can generate the AWR report and manually search the sql using sql_id
or query string.
:-)

Oracle provide a easy method.

Using dbms_workload_repository.awr_sql_report_text function, we can
easily find whether sql query captured or not.

select * from table(dbms_workload_repository.awr_sql_report_text
(&v_db_id, &v_inst_num, :b_snap_id, :e_snap_id, '&v_sql_id'));

I Hope this article helped to you. I am expecting your suggestions/feedback.
It will help to motivate me to write more articles.

Best Regards
Rajabaskar Thangaraj