Oracle DBMS_AWR_REPORT_LAYOUT
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,
Purpose ASH and AWR Reporting
AUTHID DEFINER
Dependencies
DBMS_ASH_INTERNAL DBMS_SWRF_REPORT_INTERNAL  
Documented No
First Available 11.2.0.1
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvsawrs.plb
Subprograms
 
ASH_BUILD_REPORT_CHAPTERS
Undocumented dbms_awr_report_layout.ash_build_report_chapters(
rpt_tree IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE,
title    IN OUT VARCHAR2,
is_leaf  IN OUT BOOLEAN,
children IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE_CHILDREN);
TBD
 
ASH_BUILD_REPORT_SECTIONS
Undocumented dbms_awr_report_layout.ash_build_report_sections(
rpt_secs   IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_REC_TAB,
title      IN OUT VARCHAR2,
comments   IN OUT VARCHAR2,
summary    IN OUT VARCHAR2,
sqlstr     IN OUT CLOB,
binds      IN OUT DBMS_AWR_REPORT_LAYOUT.BINDS_TAB,
options    IN OUT BINARY_INTEGER,
row_desc   IN OUT DBMS_AWR_REPORT_LAYOUT.COL_REC_TAB,
type       IN OUT BINARY_INTEGER,
subtype    IN OUT BINARY_INTEGER,
enhance    IN OUT BINARY_INTEGER,
agg        IN OUT BINARY_INTEGER,
format     IN OUT VARCHAR2,
heading    IN OUT VARCHAR2,
master_id  IN OUT VARCHAR2,
nl_pos     IN OUT DBMS_AWR_REPORT_LAYOUT.POS_TAB,
master_hdr IN OUT DBMS_AWR_REPORT_LAYOUT.MASTER_TAB,
text       IN OUT VARCHAR2,
min_col    IN OUT BINARY_INTEGER,
max_col    IN OUT BINARY_INTEGER
hdr_row    IN OUT DBMS_AWR_REPORT_LAYOUT.HDR_TAB);
TBD
 
AWRG_BUILD_REPORT_CHAPTERS
Undocumented dbms_awr_report_layout.awrg_build_report_chapters(
rpt_tree IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE,
title    IN OUT VARCHAR2,
is_leaf  IN OUT BOOLEAN,
children IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE_CHILDREN);
TBD
 
AWRG_BUILD_REPORT_SECTIONS
Undocumented dbms_awr_report_layout.awrg_build_report_sections(
rpt_secs   IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_REC_TAB,
title      IN OUT VARCHAR2,
comments   IN OUT VARCHAR2,
summary    IN OUT VARCHAR2,
sqlstr     IN OUT CLOB,
binds      IN OUT DBMS_AWR_REPORT_LAYOUT.BINDS_TAB,
options    IN OUT BINARY_INTEGER,
row_desc   IN OUT DBMS_AWR_REPORT_LAYOUT.COL_REC_TAB,
type       IN OUT BINARY_INTEGER,
subtype    IN OUT BINARY_INTEGER,
enhance    IN OUT BINARY_INTEGER,
agg        IN OUT BINARY_INTEGER,
format     IN OUT VARCHAR2,
heading    IN OUT VARCHAR2,
master_id  IN OUT VARCHAR2,
nl_pos     IN OUT DBMS_AWR_REPORT_LAYOUT.POS_TAB,
master_hdr IN OUT DBMS_AWR_REPORT_LAYOUT.MASTER_TAB,
text       IN OUT VARCHAR2,
min_col    IN OUT BINARY_INTEGER,
max_col    IN OUT BINARY_INTEGER
hdr_row    IN OUT DBMS_AWR_REPORT_LAYOUT.HDR_TAB);
TBD
 
AWR_BUILD_REPORT_CHAPTERS
Undocumented dbms_awr_report_layout.awr_build_report_chapters(
rpt_tree IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE,
title    IN OUT VARCHAR2,
is_leaf  IN OUT BOOLEAN,
children IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE_CHILDREN);
TBD
 
AWR_BUILD_REPORT_SECTIONS
Undocumented dbms_awr_report_layout.awr_build_report_sections(
rpt_secs   IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_REC_TAB,
title      IN OUT VARCHAR2,
comments   IN OUT VARCHAR2,
summary    IN OUT VARCHAR2,
sqlstr     IN OUT CLOB,
binds      IN OUT DBMS_AWR_REPORT_LAYOUT.BINDS_TAB,
options    IN OUT BINARY_INTEGER,
row_desc   IN OUT DBMS_AWR_REPORT_LAYOUT.COL_REC_TAB,
type       IN OUT BINARY_INTEGER,
subtype    IN OUT BINARY_INTEGER,
enhance    IN OUT BINARY_INTEGER,
agg        IN OUT BINARY_INTEGER,
format     IN OUT VARCHAR2,
heading    IN OUT VARCHAR2,
master_id  IN OUT VARCHAR2,
nl_pos     IN OUT DBMS_AWR_REPORT_LAYOUT.POS_TAB,
master_hdr IN OUT DBMS_AWR_REPORT_LAYOUT.MASTER_TAB,
text       IN OUT VARCHAR2,
min_col    IN OUT BINARY_INTEGER,
max_col    IN OUT BINARY_INTEGER
hdr_row    IN OUT DBMS_AWR_REPORT_LAYOUT.HDR_TAB);
TBD
 
DBFUS_BUILD_REPORT_CHAPTERS
Undocumented dbms_awr_report_layout.dbfus_build_report_chapters(
rpt_tree IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE,
title    IN OUT VARCHAR2,
is_leaf  IN OUT BOOLEAN,
children IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE_CHILDREN);
TBD
 
DBFUS_BUILD_REPORT_SECTIONS
Undocumented dbms_awr_report_layout.dbfus_build_report_sections(
rpt_secs   IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_REC_TAB,
title      IN OUT VARCHAR2,
comments   IN OUT VARCHAR2,
sqlstr     IN OUT CLOB,
binds      IN OUT DBMS_AWR_REPORT_LAYOUT.BINDS_TAB,
options    IN OUT BINARY_INTEGER,
row_desc   IN OUT DBMS_AWR_REPORT_LAYOUT.COL_REC_TAB,
type       IN OUT BINARY_INTEGER,
subtype    IN OUT BINARY_INTEGER,
enhance    IN OUT BINARY_INTEGER,
agg        IN OUT BINARY_INTEGER,
format     IN OUT VARCHAR2,
heading    IN OUT VARCHAR2,
nl_pos     IN OUT DBMS_AWR_REPORT_LAYOUT.POS_TAB,
master_hdr IN OUT DBMS_AWR_REPORT_LAYOUT.MASTER_TAB,
text       IN OUT VARCHAR2,
min_col    IN OUT BINARY_INTEGER,
max_col    IN OUT BINARY_INTEGER
hdr_row    IN OUT DBMS_AWR_REPORT_LAYOUT.HDR_TAB);
TBD
 
DIFF_BUILD_REPORT_CHAPTERS
Undocumented dbms_awr_report_layout.diff_build_report_chapters(
rpt_tree IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE,
title    IN OUT VARCHAR2,
is_leaf  IN OUT BOOLEAN,
children IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE_CHILDREN);
TBD
 
DIFF_BUILD_REPORT_SECTIONS
Undocumented dbms_awr_report_layout.diff_build_report_sections(
rpt_secs   IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_REC_TAB,
title      IN OUT VARCHAR2,
comments   IN OUT VARCHAR2,
summary    IN OUT VARCHAR2,
sqlstr     IN OUT CLOB,
binds      IN OUT DBMS_AWR_REPORT_LAYOUT.BINDS_TAB,
options    IN OUT BINARY_INTEGER,
row_desc   IN OUT DBMS_AWR_REPORT_LAYOUT.COL_REC_TAB,
type       IN OUT BINARY_INTEGER,
subtype    IN OUT BINARY_INTEGER,
enhance    IN OUT BINARY_INTEGER,
agg        IN OUT BINARY_INTEGER,
format     IN OUT VARCHAR2,
heading    IN OUT VARCHAR2,
master_id  IN OUT VARCHAR2,
nl_pos     IN OUT DBMS_AWR_REPORT_LAYOUT.POS_TAB,
master_hdr IN OUT DBMS_AWR_REPORT_LAYOUT.MASTER_TAB,
text       IN OUT VARCHAR2,
min_col    IN OUT BINARY_INTEGER,
max_col    IN OUT BINARY_INTEGER
hdr_row    IN OUT DBMS_AWR_REPORT_LAYOUT.HDR_TAB);
TBD
 
DIFFG_BUILD_REPORT_CHAPTERS
Undocumented dbms_awr_report_layout.diffg_build_report_chapters(
rpt_tree IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE,
title    IN OUT VARCHAR2,
is_leaf  IN OUT BOOLEAN,
children IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE_CHILDREN);
TBD
 
DIFFG_BUILD_REPORT_SECTIONS
Undocumented dbms_awr_report_layout.diffg_build_report_sections(
rpt_secs   IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_REC_TAB,
title      IN OUT VARCHAR2,
comments   IN OUT VARCHAR2,
summary    IN OUT VARCHAR2,
sqlstr     IN OUT CLOB,
binds      IN OUT DBMS_AWR_REPORT_LAYOUT.BINDS_TAB,
options    IN OUT BINARY_INTEGER,
row_desc   IN OUT DBMS_AWR_REPORT_LAYOUT.COL_REC_TAB,
type       IN OUT BINARY_INTEGER,
subtype    IN OUT BINARY_INTEGER,
enhance    IN OUT BINARY_INTEGER,
agg        IN OUT BINARY_INTEGER,
format     IN OUT VARCHAR2,
heading    IN OUT VARCHAR2,
master_id  IN OUT VARCHAR2,
nl_pos     IN OUT DBMS_AWR_REPORT_LAYOUT.POS_TAB,
master_hdr IN OUT DBMS_AWR_REPORT_LAYOUT.MASTER_TAB,
text       IN OUT VARCHAR2,
min_col    IN OUT BINARY_INTEGER,
max_col    IN OUT BINARY_INTEGER
hdr_row    IN OUT DBMS_AWR_REPORT_LAYOUT.HDR_TAB);
TBD
 
SQL_BUILD_REPORT_CHAPTERS
Undocumented dbms_awr_report_layout.sql_build_report_chapters(
rpt_tree IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE,
title    IN OUT VARCHAR2,
is_leaf  IN OUT BOOLEAN,
children IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE_CHILDREN);
TBD
 
SQL_BUILD_REPORT_SECTIONS
Undocumented dbms_awr_report_layout.sql_build_report_sections(
rpt_secs   IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_REC_TAB,
title      IN OUT VARCHAR2,
comments   IN OUT VARCHAR2,
summary    IN OUT VARCHAR2,
sqlstr     IN OUT CLOB,
binds      IN OUT DBMS_AWR_REPORT_LAYOUT.BINDS_TAB,
options    IN OUT BINARY_INTEGER,
row_desc   IN OUT DBMS_AWR_REPORT_LAYOUT.COL_REC_TAB,
type       IN OUT BINARY_INTEGER,
subtype    IN OUT BINARY_INTEGER,
enhance    IN OUT BINARY_INTEGER,
agg        IN OUT BINARY_INTEGER,
format     IN OUT VARCHAR2,
heading    IN OUT VARCHAR2,
master_id  IN OUT VARCHAR2,
nl_pos     IN OUT DBMS_AWR_REPORT_LAYOUT.POS_TAB,
master_hdr IN OUT DBMS_AWR_REPORT_LAYOUT.MASTER_TAB,
text       IN OUT VARCHAR2,
min_col    IN OUT BINARY_INTEGER,
max_col    IN OUT BINARY_INTEGER
hdr_row    IN OUT DBMS_AWR_REPORT_LAYOUT.HDR_TAB);
TBD
 
WCR_BUILD_REPORT_CHAPTERS
Undocumented dbms_awr_report_layout.wcr_build_report_chapters(
rpt_tree IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE,
title    IN OUT VARCHAR2,
is_leaf  IN OUT BOOLEAN,
children IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_TREE_CHILDREN);
TBD
 
WCR_BUILD_REPORT_SECTIONS
Undocumented dbms_awr_report_layout.wcr_build_report_sections(
rpt_secs   IN OUT DBMS_AWR_REPORT_LAYOUT.SEC_REC_TAB,
title      IN OUT VARCHAR2,
comments   IN OUT VARCHAR2,
summary    IN OUT VARCHAR2,
sqlstr     IN OUT CLOB,
binds      IN OUT DBMS_AWR_REPORT_LAYOUT.BINDS_TAB,
options    IN OUT BINARY_INTEGER,
row_desc   IN OUT DBMS_AWR_REPORT_LAYOUT.COL_REC_TAB,
type       IN OUT BINARY_INTEGER,
subtype    IN OUT BINARY_INTEGER,
enhance    IN OUT BINARY_INTEGER,
agg        IN OUT BINARY_INTEGER,
format     IN OUT VARCHAR2,
heading    IN OUT VARCHAR2,
master_id  IN OUT VARCHAR2,
nl_pos     IN OUT DBMS_AWR_REPORT_LAYOUT.POS_TAB,
master_hdr IN OUT DBMS_AWR_REPORT_LAYOUT.MASTER_TAB,
text       IN OUT VARCHAR2,
min_col    IN OUT BINARY_INTEGER,
max_col    IN OUT BINARY_INTEGER
hdr_row    IN OUT DBMS_AWR_REPORT_LAYOUT.HDR_TAB);
TBD

Related Topics
AWR Report
Packages

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