AWR – DB Report with dbms_workload_repository Package

* You can use dbms_workload_repository package to generate AWR DB Reports.

AWR_REPORT_TEXT

AWR_REPORT_HTML

SELECT OUTPUT FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_REPORT_HTML (2934657915,1,33907,33913);

* You can also use same pakcage to generate AWR DB comparison reports.

AWR_DIFF_REPORT_TEXT

AWR_DIFF_REPORT_HTML

SELECT OUTPUT FROM TABLE(DBMS_WORKLOAD_REPOSITORY.AWR_DIFF_REPORT_HTML( 2934657915,1,33907,33913, 2934657915,1,43981,44832);

Advertisement