Oracle | DBMS_DATA_GUARD

Oracle DBMS_DATA_GUARD_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 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 23ai

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 23ai)

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 23ai)

Cleans up post AWR report creation dbms_data_guard_internal.report_cleanup;

exec dbms_data_guard_internal.report_cleanup;

      

      PL/SQL procedure successfully completed.