Oracle DBMS_AWR_REPORT_LAYOUT
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvsawrs.plb
Subprograms
ASH_BUILD_REPORT_CHAPTERS DBFUS_BUILD_REPORT_CHAPTERS DIFF_EXA_BUILD_REPORT_SECTIONS
ASH_BUILD_REPORT_SECTIONS DBFUS_BUILD_REPORT_SECTIONS EXADATA_BUILD_REPORT_CHAPTERS
AWRG_BUILD_REPORT_CHAPTERS DIFFG_BUILD_REPORT_CHAPTERS EXADATA_BUILD_REPORT_SECTIONS
AWRG_BUILD_REPORT_SECTIONS DIFFG_BUILD_REPORT_SECTIONS SQL_BUILD_REPORT_CHAPTERS
AWR_BUILD_ASH_REPORT_SECTIONS DIFF_BUILD_REPORT_CHAPTERS SQL_BUILD_REPORT_SECTIONS
AWR_BUILD_REPORT_CHAPTERS DIFF_BUILD_REPORT_SECTIONS WCR_BUILD_REPORT_CHAPTERS
AWR_BUILD_REPORT_SECTIONS DIFF_EXA_BUILD_REPORT_CHAPTERS WCR_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,
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 19c
What's New In 20c-21c

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