Oracle | DBMS_AUTO_REPORT

Oracle DBMS_AUTO_REPORT_INTERNAL 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 Support package for DBMS_AUTO_REPORT

AUTHID DEFINER

Dependencies

AWR_CDB_REPORT_DETAILS	DBMS_REPORT_LIB	UTL_COMPRESS
AWR_PDB_REPORT_DETAILS	DBMS_SQLTUNE_UTIL1	WRP$_REPORTS
AWR_ROOT_REPORTS_DETAILS	DBMS_SQLTUNE_UTIL2	WRP$_REPORTS_DETAILS
DBA_HIST_REPORTS_DETAILS	DUAL	WRP$_REPORTS_TIME_BANDS
DBMS_LOB	PLITBLM	WRP$_REPORT_ID_SEQ
DBMS_REPORT	PRVT_RTADDM	XMLTYPE

Documented No

First Available 12.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvsautorepi.plb

Subprograms

I_SAVE_REPORT

I_UNCOMPRESS_REPORT

I_SAVE_REPORT

Undocumented dbms_auto_report_internal.i_save_report( report_ref IN VARCHAR2, snap_id IN BINARY_INTEGER, pr_class IN BINARY_INTEGER, report_id OUT BINARY_INTEGER, success OUT BINARY_INTEGER);

TBD

I_UNCOMPRESS_REPORT

Undocumented dbms_auto_report_internal.i_uncompress_report(report_in IN BLOB) RETURN CLOB;

-- the following code from catrepv.sql illustrates this function's use

      

      CREATE OR REPLACE VIEW dba_hist_reports_details

      (SNAP_ID, DBID, INSTANCE_NUMBER, REPORT_ID, SESSION_ID,

       SESSION_SERIAL#, GENERATION_TIME, REPORT_COMPRESSED, REPORT)

      AS

      SELECT snap_id, dbid, instance_number, report_id,

        session_id, session_serial#, generation_time, report_compressed,

        dbms_auto_report_internal.i_uncompress_report(report_compressed)

      FROM wrp$_reports_details d

      /