The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to
12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain
references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);

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);