Oracle DBMS_AWR_REPORT_LAYOUT
Version 21c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
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 21c
What's New In 23c

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