Results for “prepare_column_values_rowid”

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

Overview

SYS.DBMS_STATS is the Oracle-supplied statistics management package that serves as the foundation for cost-based optimizer (CBO) decisions across the Oracle E-Business Suite database. Although it resides in the SYS schema and is not an EBS application object, it is a critical dependency for EBS 12.1.1 and 12.2.2 because the performance of every EBS form, concurrent program, and online transaction depends on the accuracy of optimizer statistics gathered by this package. In the ETRM metadata it is classified as API classification OTHER and is referenced by 45 other packages, confirming its pervasive role as infrastructure relied upon by EBS optimization utilities, the Gather Schema Statistics concurrent program (FND_STATS), and AutoConfig-driven maintenance routines.

Key Procedures and Functions

The package body exposes 151 documented procedures and functions, logically grouped as follows:

• Statistic collection helpers: PREPARE_COLUMN_VALUES, PREPARE_COLUMN_VALUES_NVARCHAR, and PREPARE_COLUMN_VALUES_ROWID prepare column data for histogram and statistics gathering, handling standard, national character set, and ROWID data types respectively.
• Parameter management: SET_PARAM, GET_PARAM, and RESET_PARAM_DEFAULTS control the runtime parameters that govern how statistics are gathered, retrieved, or reset to defaults.
• Global preferences: SET_GLOBAL_PREFS, GET_PREFS, and RESET_GLOBAL_PREF_DEFAULTS configure database-wide statistics collection preferences.
• Table-level preferences: SET_TABLE_PREFS and DELETE_TABLE_PREFS, with EXPORT_TABLE_PREFS and IMPORT_TABLE_PREFS to move preference settings between environments.
• Schema-level preferences: SET_SCHEMA_PREFS and DELETE_SCHEMA_PREFS, with corresponding EXPORT_SCHEMA_PREFS and IMPORT_SCHEMA_PREFS routines.
• Database-level preferences: SET_DATABASE_PREFS and DELETE_DATABASE_PREFS, with EXPORT_DATABASE_PREFS for portability.

Additional entry points beyond the excerpt provide statistics gathering, deletion, copying, and locking operations. All procedures execute under SYS privileges, so callers must have EXECUTE granted directly or through a role.

Tables Accessed

DBMS_STATS reads from and writes to the data dictionary statistics views and base tables — principally TAB$, COL$, IND$, and the SYS-owned statistics storage underlying DBA_TAB_STATISTICS, DBA_TAB_COL_STATISTICS, and DBA_IND_STATISTICS — rather than EBS application tables. No APPS synonyms are documented for this package. EBS components such as FND_STATS invoke DBMS_STATS indirectly to populate statistics for the APPS schema and its product schemas; the package itself manages the repository of optimizer statistics, not transactional business data.

Usage Notes

In EBS 12.1.1 and 12.2.2, DBMS_STATS is typically invoked indirectly through the Gather Schema Statistics concurrent program and related FND_STATS procedures, or through scheduled database maintenance jobs. Because this is a wrapped package body ("package body dbms_stats wrapped" appears in the source), the implementation is obfuscated and cannot be customized; modifications are not supported and would invalidate Oracle certification. The search term "?bcx" that led to this document does not correspond to any documented parameter or procedure in the ETRM metadata and is likely a partial or mistyped query. Oracle recommends that all EBS statistics be gathered with the preferences set through this package rather than through manual ANALYZE commands, since optimizer correctness and supportability depend on consistent use of DBMS_STATS.