Oracle DBMS_AWR_REPORT_LAYOUT
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers? Software Defined Servers can improve performance and security while lowering complexity and cost. With Software Defined Servers you define servers with an optimum configuration to your environment rather than being memory starved and cpu over-provisioned. Find out how you can improve your computing environment with TidalScale. your friends.
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_SWRF_REPORT_INTERNAL PLITBLM
DBMS_AWR_PROTECTED DBMS_UMF_PROTECTED  
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
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
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
Built-in Functions
Built-in Packages
DBMS_MANAGEMENT_BOOTSTRAP
DBMS_MANAGEMENT_PACKS
DBMS_WORKLOAD_REPOSITORY
What's New In 12cR2
What's New In 18cR3

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