Search Results dbms_ash_internal




Overview
Explore in AI Chat

Overview

SYS.DBMS_ASH_INTERNAL is an Oracle-supplied PL/SQL package that forms part of the Active Session History (ASH) infrastructure within the Oracle database kernel. In Oracle EBS 12.1.1 and 12.2.2, the package is not an E-Business Suite application object; it resides in the SYS schema and is shipped with the Oracle Database release (10g and later) rather than with the EBS technology stack. Its business function is to provide the internal implementation that supports ASH data retrieval, sampling, and presentation, most notably for the Active Session History report and the Active Session History Viewer (ASH Viewer) used by database administrators and performance analysts. Within an EBS environment, this package underpins diagnostics that help support teams identify which sessions, SQL statements, and wait events consumed database time during a period of poor application performance.

ETRM 12.2.2 documents the object as VALID with an API classification of OTHER, indicating that it is an internal, undocumented kernel package rather than a public, supported application programming interface.

Key Procedures and Functions

The ETRM metadata records zero documented procedures or functions for SYS.DBMS_ASH_INTERNAL. This is consistent with the package being an internal implementation body whose entry points are not published for customer use. Its behavior is exercised indirectly: the dependency listing shows the package is referenced by DBMS_ASH_INTERNAL itself (the public package that exposes ASH functionality), by ASHVIEWER (the viewer component), and by a set of related reporting and repository packages including DBMS_AWR_REPORT_LAYOUT, DBMS_PERF, DBMS_SWRF_REPORT_INTERNAL, DBMS_WORKLOAD_REPOSITORY, DBMS_WRR_INTERNAL, PRVTEMX_PERF, PRVT_AWR_DATA, PRVT_AWR_VIEWER, and WRI$_REPT_ASH. Because no parameter lists are documented, no signatures are reproduced here; the package should be treated as a callable-only-through-supported-wrappers component.

Tables Accessed

The ETRM dependency data does not enumerate base tables accessed through APPS synonyms for this object, which is expected because SYS.DBMS_ASH_INTERNAL operates on database-level ASH and AWR repository structures rather than on EBS application tables. Its type dependencies are recorded as AWRRPT_INSTANCE_LIST_TYPE, STANDARD, and XMLTYPE, reflecting the use of instance-list collections and XML generation in report output. The reference from WRI$_REPT_ASH and PRVT_AWR_DATA indicates that the package interacts with the Workload Repository report infrastructure that supplies ASH rows for display in the Active Session History report. In an EBS context, such data is queried from the database's ASH buffers and AWR repository, not from EBS schemas such as AP, GL, or FND.

Usage Notes

SYS.DBMS_ASH_INTERNAL is typically invoked indirectly during execution of the Active Session History report and the ASH Viewer, both of which are database performance tools that may be launched from Oracle Enterprise Manager or from SQL*Plus against an EBS database. It is not called from EBS Forms, concurrent programs, or Oracle Application Framework pages, and no EBS product code depends on it. Because the package is owned by SYS, is undocumented, and is not covered by Oracle EBS support agreements, custom code should never call it directly; any such invocation risks failure on database upgrade or patch application. Administrators diagnosing EBS performance issues should use the supported ASH and AWR reports, which invoke this internal package on their behalf.