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 is now availble. If you haven't you downloaded already: Why?

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

      /