Oracle | DBMS_ADAT

Oracle DBMS_ADAT_REPORT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Automatic Workload Repository (AWR) administrator's application report intended for the creation of AWR Reports.

AUTHID DEFINER

Dependencies

DBMS_ADAT_REPORT_LIB

Documented No

First Available 23ai

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, READ_ONLY);

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

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

Subprograms

GENERATE_ADAT_REPORT

GENERATE_ADAT_REPORT (new 23ai)

Undocumented

Unable to run report in Beta because ORA-15900 AWR Analytics operation failed: features is disabled. dbms_adat_report.generate_adat_report( dbid IN NUMBER, beg_snap IN NUMBER, end_snap IN NUMBER, inst_val IN VARCHAR2 DEFAULT 'ALL', format IN VARCHAR2 DEFAULT 'JSON', options IN CLOB DEFAULT NULL) RETURN CLOB;

TBD