Results for “dbms_system”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

SYS.DBMS_SYSTEM is an Oracle-supplied, undocumented or lightly documented PL/SQL package owned by the SYS schema. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, it is bundled as a wrapped (obfuscated) package body, as reflected in the stored source. Within the ETRM 12.2.2 repository, the object is classified under API classification OTHER, indicating it is an infrastructure-level utility rather than a business application programming interface.

The package provides low-level session and instance diagnostic procedures that allow DBAs and privileged sessions to set trace events, manage event numbers, read and modify the current session's diagnostic state, and manage signal handling for the database instance. In the EBS context, these capabilities are typically exercised during performance troubleshooting, FND debugging, or Oracle Support-driven diagnostic sessions rather than during normal application processing. The metadata records zero documented procedures or functions for this object, which is consistent with its status as a wrapped, internal SYS utility where the callable surface is not exposed through ETRM.

Key Procedures and Functions

The ETRM record lists 0 documented procedures or functions for SYS.DBMS_SYSTEM. No parameter lists, entry points, or signatures are published in the repository excerpt provided, and the wrapped body conceals the implementation. Consequently, no specific callable names should be inferred from the metadata itself.

For reference, the package is widely recognized in Oracle documentation as exposing routines associated with event management (for example, setting and clearing event numbers for the current session or instance) and with session-level trace control. Where an EBS implementation needs to enable tracing or an event for diagnosis, the more commonly supported and documented alternatives are SYS.DBMS_SESSION and SYS.DBMS_MONITOR; DBMS_SYSTEM is generally reserved for cases where those higher-level interfaces are insufficient. Because the package carries no documented EBS-level API contract, any invocation should be treated as an advanced, DBA-supervised activity.

Tables Accessed

ETRM reports no tables referenced via APPS synonyms for this package. This absence is expected: DBMS_SYSTEM is a kernel-oriented utility that manipulates session and instance state through internal Oracle mechanisms rather than by querying or updating EBS application tables in the APPS schema.

Because no application tables are accessed, the package does not participate in EBS data integrity flows, concurrent program data dependencies, or the standard FND_* logging tables. Its effects are felt at the database instance level (event and trace settings) rather than through row-level changes to business data.

Usage Notes

The ETRM metadata indicates that SYS.DBMS_SYSTEM is referenced by 128 other packages within the repository. This high inbound dependency count reflects its role as a shared SYS-level utility called by numerous database-resident components, including Oracle platform packages. It does not indicate that EBS business packages invoke it directly as part of a documented API; rather, it is a dependency of low-level infrastructure.

Typical invocation contexts include:

• DBA-initiated diagnostic sessions where event or trace settings must be applied to the current session or the instance.
• Oracle Support engagements that require enabling internal events to collect diagnostic dumps.
• Performance tuning where session-level tracing is required beyond the granularity provided by DBMS_SESSION or DBMS_MONITOR.

Direct calls from EBS Forms, concurrent programs, or custom application code should be avoided. The package is undocumented for EBS purposes, its body is wrapped, and its use is generally not supported outside DBA or Oracle Support direction. Any reference to it in custom code constitutes an unsupported dependency on a SYS-owned, internal interface.