Search Results dbms_streams_advisor_adm




Overview
Explore in AI Chat

Overview

SYS.DBMS_STREAMS_ADVISOR_ADM is an Oracle-supplied PL/SQL package body that forms part of the Oracle Streams Advisor infrastructure. In the context of Oracle E-Business Suite 12.1.1 and 12.2.2, this package provides the administrative and analytical entry points used to assess the health, configuration, and throughput of an Oracle Streams environment. Streams is the underlying replication and message-propagation technology used by EBS for several data-sharing and information-distribution features, and it is also indirectly relevant to Advanced Queuing and change-data-capture workloads that depend on the Streams capture and apply processes.

The package is owned by SYS and is documented as VALID in the 12.2.2 reference metadata. Its API classification is recorded as OTHER, indicating that it is not a core EBS application-program interface but an Oracle database utility that may be invoked by DBA tooling or diagnostic scripts. The package body does not depend on any EBS application schema directly; rather it serves as a thin administrative layer over the lower-level Streams advisor utilities.

Key Procedures and Functions

The documented metadata lists a single public procedure or function for this package: ANALYZE_CURRENT_PERFORMANCE.

  • ANALYZE_CURRENT_PERFORMANCE — Performs an analysis of the current performance characteristics of the Streams environment. It gathers and evaluates runtime metrics associated with the configured capture, propagation, and apply processes so that the administrator can identify bottlenecks, latency, or misconfiguration. This is an advisor-style routine: it does not itself modify the replication configuration but produces diagnostic output that drives remediation decisions.

Only this one entry point is documented for the package. The full implementation relies on several internal helper packages, including DBMS_STREAMS_ADV_ADM_UTL, DBMS_STREAMS_ADV_ADM_UTL_INVOK, DBMS_STREAMS_ADM, and DBMS_LOGREP_UTIL, which carry out the granular metric collection and invocation plumbing. These are private dependencies and are not intended to be called directly by EBS administrators.

Tables Accessed

The reference metadata does not enumerate any APPS-schema tables or synonyms accessed by this package. Consistent with its role as a SYS-owned advisor utility, the package reads from Oracle Streams dictionary and runtime views rather than from EBS application tables. The internal utility packages resolved at runtime supply the actual data sources, which include the Streams capture, propagation, and apply statistics maintained in the data dictionary. Because no application tables are referenced, invoking the package does not affect EBS transactional data integrity.

Usage Notes

This package is typically invoked directly from SQL*Plus or another DBA client by a database administrator investigating Streams performance, rather than from an EBS concurrent program or form. It is not wired into standard EBS navigation menus. Typical invocation scenarios include:

  • Diagnosing replication lag or throughput degradation in an EBS environment that uses Streams-based information distribution.
  • Pre- and post-change validation when tuning Streams capture or apply parameters.
  • Ad-hoc health checks as part of database performance troubleshooting.

Because the package is owned by SYS and is not referenced by any other database object, it is isolated from the EBS application dependency graph. Execute privileges are therefore restricted to privileged accounts, and use should follow standard change-control practice for direct database-level operations. In EBS 12.2.2 the package remains VALID, confirming it is present and compiled in a supported state for that release.