Oracle DBMS_AWR_REPORT_LAYOUT
Version 11.2.0.3
 
General Information
Purpose ASH and AWR Reporting
Source {ORACLE_HOME}/rdbms/admin/prvsawrs.plb
First Available 11.2
Dependencies
DBMS_ASH_INTERNAL DBMS_SWRF_REPORT_INTERNAL
Security Model Owned by SYS: No privileges granted
Subprograms
ASH_BUILD_REPORT_CHAPTERS DBFUS_BUILD_REPORT_CHAPTERS SQL_BUILD_REPORT_CHAPTERS
ASH_BUILD_REPORT_SECTIONS DBFUS_BUILD_REPORT_SECTIONS SQL_BUILD_REPORT_SECTIONS
AWR_BUILD_REPORT_CHAPTERS DIFF_BUILD_REPORT_CHAPTERS WCR_BUILD_REPORT_CHAPTERS
AWR_BUILD_REPORT_SECTIONS DIFF_BUILD_REPORT_SECTIONS WCR_BUILD_REPORT_SECTIONS
AWRG_BUILD_REPORT_CHAPTERS DIFFG_BUILD_REPORT_CHAPTERS  
AWRG_BUILD_REPORT_SECTIONS DIFFG_BUILD_REPORT_SECTIONS  
 
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 (new 11.2.0.3 parameters)
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
 
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 (new 11.2.0.3 parameters)
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
 
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 (new 11.2.0.3 parameters)
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
 
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 (new 11.2.0.3 parameters)
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 (new 11.2.0.3 parameters)
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 (new 11.2.0.3 parameters)
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 (new 11.2.0.3 parameters)
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-2013 Daniel A. Morgan All Rights Reserved