My Oracle Support Banner

How to Determine if Dictionary Statistics are RDBMS-Generated or User-Defined (Doc ID 130911.1)

Last updated on MAY 20, 2024

Applies to:

Oracle Database - Enterprise Edition
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Purpose

The purpose of this article is to explain how to determine if your
dictionary statistics are RDBMS-generated or set by users through one
of the DBMS_STATS.SET_xx_STATS procedures in version Oracle 8i and higher

Scope

During an application development phase, you are testing the performance of
SQL statements with various sets of statistics. You may need to know if the
relying statistics are RDBMS-defined or user-defined. How to determine
this information in Oracle 8i is explained in this article.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.