My Oracle Support Banner

How to Set User-Defined Statistics Instead of RDBMS Statistics (Doc ID 130899.1)

Last updated on MAY 15, 2024

Applies to:

Oracle Database - Enterprise Edition - Version and later
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 Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


During your performance testing of SQL statements, you need to simulate
different workloads and therefore different underlying statistics.

The purpose of this article is to explain how to set user-defined statistics
in the dictionary replacing those generated by the DBMS_STATS package
or ANALYZE statement.


This article is intended to help all database administrators and developers for SQL Tuning purposes.


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.