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'));
No comments:
Post a Comment