Search Results dbms_feature_usage_internal




Overview
Explore in AI Chat

Overview

SYS.DBMS_FEATURE_USAGE_INTERNAL is a core Oracle Database-supplied PL/SQL package owned by the SYS schema. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, it provides the internal engine that supports the database's Feature Usage and High Water Mark (HWM) tracking infrastructure. This infrastructure records which database features and optional components are actually exercised at runtime, storing statistics that Oracle later reads through the public DBMS_FEATURE_USAGE and DBA_FEATURE_USAGE_STATISTICS interfaces. The package therefore does not implement EBS application logic; rather, it is a database kernel component that the EBS technology stack depends on for diagnostics, license compliance verification, and support data collection. In ETRM the object is classified with an API classification of OTHER, and the recorded status is VALID. It is a wrapped, undocumented internal package: ETRM lists no documented procedures, no referenced APPS-synonym tables, and no downstream packages that invoke it.

Key Procedures and Functions

The ETRM metadata documents zero procedures or functions for this package. The published specification is not exposed, and no parameter lists are recorded. Consequently, no callable entry points can be enumerated from the reference material, and none should be assumed. Practically, the package exposes internal instrumentation routines that the database invokes automatically when a tracked feature is first exercised. These routines maintain and update feature-usage records rather than offering a supported API surface to application developers. Because the body is wrapped and no subprograms are documented, the package must be treated as a black box. Custom code should never call it directly; any interaction with feature-usage data should go through the supported public interfaces such as DBMS_FEATURE_USAGE or the corresponding data dictionary views.

Tables Accessed

ETRM records no tables referenced through APPS synonyms, which is consistent with a SYS-owned database component. The package operates on internal fixed tables and dictionary objects that hold the persisted feature-usage and high-water-mark statistics surfaced through DBA_FEATURE_USAGE_STATISTICS and DBA_HIGH_WATER_MARK_STATISTICS. Because these objects reside in the SYS schema and are not exposed via APPS synonyms, EBS application schemas have no direct access path to them. No EBS application tables are read or written by this package.

Usage Notes

DBMS_FEATURE_USAGE_INTERNAL is invoked implicitly by the Oracle database server, not by EBS forms, concurrent programs, or custom PL/SQL. It is triggered when a session first uses a monitored feature, and its statistics are sampled periodically through the Automatic Workload Repository. EBS administrators encounter it indirectly through support bundles, license-audit queries, and database health checks. It is not a supported extension point: it cannot be called, modified, or recompiled by application developers, and it should not be included in custom dependency chains. The internal body is wrapped and proprietary, and its behavior is governed by the database release rather than by the EBS application code level. For EBS 12.1.1 and 12.2.2, the package remains a valid, standard component of the database home, and any investigation of it should rely on the public feature-usage views instead of its undocumented internals.