Oracle | DBMS_DATA

Oracle DBMS_DATA_GUARD 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 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 23.2

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

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