Search Results dbms_awr_report_layout

Overview

The SYS.DBMS_AWR_REPORT_LAYOUT package is an Oracle-supplied PL/SQL package that resides in the SYS schema and holds a status of VALID within an Oracle E-Business Suite 12.1.1 or 12.2.2 database. Its role is to provide the underlying report layout logic used by Oracle's Active Workload Repository (AWR) reporting framework. This framework produces the HTML and text-based performance diagnostic output — commonly known as AWR reports — that database administrators rely upon when tuning and troubleshooting the EBS application database tier.

The package is not an EBS application object in the strict sense. It is a database-resident Oracle kernel component surfaced to EBS administrators through standard database instrumentation. In ETRM classification terms it is categorized as OTHER, reflecting that it is an internal engine package rather than a public EBS API such as those found in the APPS schema.

Key Procedures and Functions

The documented metadata for this object records zero publicly documented procedures or functions. The ETRM extract lists the package header and package body as subobjects but exposes no callable routine inventory for DBMS_AWR_REPORT_LAYOUT. This is characteristic of internal Oracle packages whose entry points are reserved for Oracle's own AWR/SWRF reporting internals and are not licensed, documented, or supported for direct customer invocation.

[Package] — the specification defining the package interface, primarily consumed by Oracle's own report-generation code rather than by EBS developers.
[Package Body] — the implementation containing the layout and formatting routines invoked during AWR report rendering.
DBMS_SWRF_REPORT_INTERNAL — the principal sibling package that references DBMS_AWR_REPORT_LAYOUT; it is the internal engine that drives System Workload Repository report generation and delegates layout tasks to this package.

No parameter lists can be asserted because none are documented; attempting to call these routines directly is neither supported nor advisable.

Tables Accessed

The ETRM metadata records no tables referenced through APPS synonyms. This is expected, since DBMS_AWR_REPORT_LAYOUT operates entirely within the SYS schema and reads from the AWR repository structures owned by SYS rather than from any EBS application table. Its data sources are therefore the Workload Repository tables populated by background MMON and AWR snapshot processes, not the transactional or setup tables that EBS functional modules use.

Usage Notes

This package executes implicitly whenever an AWR report is generated against the EBS database, whether through the awrrpt.sql / awrrpti.sql scripts, through Enterprise Manager, or through the DBMS_WORKLOAD_REPOSITORY interface. The documented dependency chain confirms that DBMS_AWR_REPORT_LAYOUT is referenced by DBMS_SWRF_REPORT_INTERNAL, meaning the layout package is downstream of the report-generation engine and upstream of no other EBS object in the documented graph.

From an EBS perspective the package is relevant only when diagnosing invalidation events on the database tier. If the package reports a status other than VALID, AWR report generation may fail or render incorrectly. Because it is an Oracle Confidential component, administrators should not attempt to modify, wrap, or invoke it from custom concurrent programs or forms. Any remediation, such as recompilation, should follow Oracle Support guidance and standard database maintenance practices rather than application-side changes.

PACKAGE: SYS.DBMS_AWR_REPORT_LAYOUT 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_AWR_REPORT_LAYOUT, status:VALID,
PACKAGE: SYS.DBMS_AWR_REPORT_LAYOUT 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_AWR_REPORT_LAYOUT, status:VALID,
PACKAGE BODY: SYS.DBMS_AWR_REPORT_LAYOUT 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_AWR_REPORT_LAYOUT, status:VALID,
PACKAGE BODY: SYS.DBMS_AWR_REPORT_LAYOUT 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_AWR_REPORT_LAYOUT, status:VALID,
PACKAGE: SYS.DBMS_SWRF_REPORT_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_SWRF_REPORT_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_AWR_PROTECTED 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_AWR_PROTECTED, status:VALID,
PACKAGE: SYS.DBMS_SWRF_REPORT_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_SWRF_REPORT_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_AWR_PROTECTED 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_AWR_PROTECTED, status:VALID,
PACKAGE: SYS.DBMS_ASH_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASH_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_ASH_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_ASH_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_SWRF_REPORT_INTERNAL 12.1.1
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_SWRF_REPORT_INTERNAL, status:VALID,
PACKAGE BODY: SYS.DBMS_SWRF_REPORT_INTERNAL 12.2.2
owner:SYS, object_type:PACKAGE BODY, object_name:DBMS_SWRF_REPORT_INTERNAL, status:VALID,
PACKAGE: SYS.DBMS_AWR_REPORT_LAYOUT 12.2.2
PACKAGE: SYS.DBMS_AWR_REPORT_LAYOUT 12.1.1
12.1.1 DBA Data 12.1.1
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
PACKAGE: SYS.PLITBLM 12.2.2
owner:SYS, object_type:PACKAGE, object_name:PLITBLM, status:VALID,
PACKAGE: SYS.PLITBLM 12.1.1
owner:SYS, object_type:PACKAGE, object_name:PLITBLM, status:VALID,
SYS.DBMS_AWR_REPORT_LAYOUT dependencies on DBMS_AWR_REPORT_LAYOUT 12.2.2
SYS.DBMS_SWRF_REPORT_INTERNAL dependencies on DBMS_AWR_REPORT_LAYOUT 12.1.1
SYS.DBMS_AWR_REPORT_LAYOUT dependencies on DBMS_AWR_REPORT_LAYOUT 12.1.1
SYS.DBMS_SWRF_REPORT_INTERNAL dependencies on DBMS_AWR_REPORT_LAYOUT 12.2.2
PACKAGE BODY: SYS.DBMS_AWR_REPORT_LAYOUT 12.1.1
PACKAGE BODY: SYS.DBMS_AWR_REPORT_LAYOUT 12.2.2
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,