Oracle | DBMS_AWR

Oracle DBMS_AWR_ANALYTICS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose AWR Analytics Report API

Support for log based replication (proj 17779) DBMS_AWR_ANALYTICS package is used for analytic functions
-- reading existing AWR data accessible through views/tables that generate no UNDO/REDO and can be replicated.

AUTHID DEFINER

Dependencies

DBMS_AUTO_TASK

DBMS_AWR_ANALYTICS_LIB

DBMS_SWRF_REPORT_INTERNAL

Documented No

Exceptions

Error Code	Reason
ORA-15900	AWR Analytics operatoin failed: feature is disabled
ORA-13509	error encountered during processing an AWR table
ORA-13516	AWR Operation failed: Request does not exist

First Available 20c

Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, READ_ONLY);

Security Model Owned by SYS with EXECUTE granted to the DBA role.

Source {ORACLE_HOME}/rdbms/admin/dbmsawrrptapp.sql
{ORACLE_HOME}/rdbms/admin/prvtawrrptapp.plb

Subprograms

AWR_REPORT_REQUEST	FETCH_REPORT	GENERATE_REPORT
CHECK_REPORT_STATUS

AWR_REPORT_REQUEST (new 23ai)

Generate a request for an AWR report in text, HTML, or Active-HTML dbms_awr_analytics.awr_report_request( l_dbid IN NUMBER, l_inst_num IN NUMBER, l_bid IN NUMBER, l_eid IN NUMBER, l_options IN NUMBER DEFAULT 0, l_format IN VARCHAR2 DEFAULT 'html', l_await IN VARCHAR2 DEFAULT 'true') RETURN NUMBER;

SELECT dbid FROM v$database;

      

            DBID

      ----------

      1405253007

      

      SELECT MAX(snap_id)-12 AS BEG_SNAP_ID, MAX(snap_id)-1 AS END_SNAPID

      FROM dba_hist_snapshot;

      

      BEG_SNAP_ID END_SNAPID

      ----------- ----------

              209        220

      

      SELECT dbms_awr_analytics.awr_report_request(1405253007, 1, 209, 220);

             *

      ORA-13509: error encountered during processing an AWR table

CHECK_REPORT_STATUS (new 23ai)

Undocumented dbms_awr_analytics.check_report_status(report_id IN NUMBER) RETURN VARCHAR2;

SELECT dbms_awr_analytics.check_report_status(2);

             *

      ORA-13516: AWR Operation failed: Request does not exist

FETCH_REPORT (new 23ai)

Fetch repot contents oafter a request with AWR_REPORT_REQUEST API dbms_awr_analytics.fetch_report(report_id IN NUMBER) RETURN CLOB;

SELECT dbms_awr_analytics.fetch_report(1);

             *

      ORA-13516: AWR Operation failed: Request does not exist

GENERATE_REPORT

Presumably generates an AWR Analytics Report if the feature is enabled dbms_awr_analytics.generate_report( dbid IN NUMBER, beg_snap IN NUMBER, end_snap IN NUMBER, format IN VARCHAR2 DEFAULT 'HTML', options IN CLOB DEFAULT NULL) RETURN CLOB;

SELECT dbid FROM v$database;

      

            DBID

      ----------

      1939439852

      

      SELECT MAX(snap_id)-12 AS BEG_SNAP_ID, MAX(snap_id)-1 AS END_SNAPID

      FROM dba_hist_snapshot;

      

      BEG_SNAP_ID END_SNAPID

      ----------- ----------

              340        351

      

      DECLARE

       retVal CLOB;

      BEGIN

        retVal := dbms_awr_analytics.generate_report(2140826538, 340, 351, 'TEXT', RetVal);

        dbms_output.put_line(retVal);

      END;

      /

      *

      ORA-15900: AWR Analytics operation failed: feature is disabled