Oracle DBMS_DATA_GUARD
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 in text format for Data Guard Physical Standbys
AUTHID DEFINER
Dependencies
AWRRPT_TEXT_TYPE DBMS_DATA_GUARD_INTERNAL PLITBLM
AWR_TEXT_TYPE_TABLE    
Documented No
First Available 23ai
Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, READ_ONLY);
Security Model Owned by SYS with EXECUTE granted to the DBA role.
Source {ORACLE_HOME}/rdbms/admin/dbmsdgawr.sql
{ORACLE_HOME}/rdbms/admin/prvtdgawr.plb
Subprograms
REPORT_TEXT    
 
REPORT_TEXT (new 23ai)
Pipelined table function that displays the Data Guard AWR report in text format dbms_data_guard.report_text(
a_dbid     IN NUMBER,
a_inst_num IN NUMBER,
a_bid      IN NUMBER,
a_eid      IN NUMBER)
RETURN awrrpt_text_type_table;
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_DATA_GUARD_INTERNAL
DBMS_DG
DBMS_DRS
What's New In 21c
What's New In 26ai

Morgan's Library Page Footer
This site is maintained by Daniel Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2026 Daniel A. Morgan All Rights Reserved