Oracle | DBMS_DATA_GUARD

Oracle DBMS_DATA_GUARD_INTERNAL Version 23c

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 Generates AWR Reports for the DBMS_DATA_GUARD built-in package.

AUTHID DEFINER

Data Types TYPE output_table IS TABLE OF ....

Dependencies

AWR_PDB_REDO_TRANSPORT_ISSUES	DBMS_SWRF_INTERNAL
AWR_PDB_SNAPSHOT	DBMS_SYSTEM
AWR_PDB_SYSSTAT	DBMS_SYS_ERROR
DBMS_DATA_GUARD	DBMS_SYS_SQL
DBMS_SQL	DBMS_UMF_INTERNAL
DBMS_STANDARD	PLITBLM

Documented No

First Available 23.2

Security Model Owned by SYS with no privileges granted.

Source {ORACLE_HOME}/rdbms/admin/dbmsdgawr.sql
{ORACLE_HOME}/rdbms/admin/prvtdgawr.plb

Subprograms

DG_REPORT_MAIN

REPORT_CLEANUP

DG_REPORT_MAIN (new 23c)

Generates the AWR report for the DBMS_DATA_GUARD package's REPORT_TEXT pipelined table function dbms_data_guard_internal.dg_report_main( a_dbid IN NUMBER, a_inst_num IN NUMBER, a_begin_snap IN NUMBER, a_end_snap IN NUMBER) RETURN dbms_data_guard_internal.output_table;

TBD

REPORT_CLEANUP (new 23c)

Cleans up post AWR report creation dbms_data_guard_internal.report_cleanup;

exec dbms_data_guard_internal.report_cleanup;

      

      PL/SQL procedure successfully completed.