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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.