Oracle | DBMS_AUTO_REPORT

Oracle DBMS_AUTO_REPORT_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Support package for DBMS_AUTO_REPORT

AUTHID DEFINER

Dependencies

DBA_HIST_REPORTS_DETAILS	DBMS_SQLTUNE_UTIL2	WRP$_REPORTS
DBMS_LOB	DUAL	WRP$_REPORTS_DETAILS
DBMS_REPORT	PLITBLM	WRP$_REPORTS_TIME_BANDS
DBMS_REPORT_LIB	PRVT_RTADDM	WRP$_REPORT_ID_SEQ
DBMS_SQLTUNE_UTIL1	UTL_COMPRESS	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

      /