Oracle DBMS_AWR_REPORT_LAYOUT
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose ASH and AWR Reporting
AUTHID DEFINER
Data Types TYPE binds_tab ...

TYPE col_rec_tab ...

TYPE layout.hdr_tab ...

TYPE master_tab ...

TYPE sec_tree ...

TYPE sec_tree_children ...
Dependencies
DBMS_ASH_INTERNAL DBMS_UMF_PROTECTED PLITBLM
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,
is_cdb   IN     BOOLEAN);
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,
is_cdb     IN     BOOLEAN);
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,
is_cdb   IN     BOOLEAN);
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,
is_cdb     IN     BOOLEAN);
TBD
 
AWR_BUILD_ASH_REPORT_SECTIONS
Undocumented dbms_awr_report_layout.awr_build_ash_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,
is_cdb     IN     BOOLEAN,
is_global  IN     BOOLEAN);
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,
is_cdb   IN     BOOLEAN);
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,
is_cdb     IN     BOOLEAN);
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,
is_cdb   IN     BOOLEAN);
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,
is_cdb     IN     BOOLEAN);
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,
is_cdb   IN     BOOLEAN);
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,
is_cdb     IN     BOOLEAN);
TBD
 
DIFF_EXA_BUILD_REPORT_CHAPTERS (new 12.2)
Undocumented dbms_awr_report_layout.diff_exa_build_report_chapters(
rpt_tree IN OUT dbms_awr_report_layout.sec_tree);
TBD
 
DIFF_EXA_BUILD_REPORT_SECTIONS (new 12.2)
Undocumented dbms_awr_report_layout.diff_exa_build_report_sections(
rpt_tree IN OUT dbms_awr_report_layout.sec_rec_tab);
TBD
 
EXADATA_BUILD_REPORT_CHAPTERS
Undocumented dbms_awr_report_layout.exadata_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
 
EXADATA_BUILD_REPORT_SECTIONS
Undocumented dbms_awr_report_layout.exadata_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,
is_cdb   IN     BOOLEAN);
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,
is_cdb     IN     BOOLEAN);
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
DBMS_MANAGEMENT_BOOTSTRAP
DBMS_MANAGEMENT_PACKS
DBMS_WORKLOAD_REPOSITORY
Packages
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved