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 will be available on generic Linux platforms in January and soon on AIX and Windows

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