My Oracle Support Banner

Automated Object Statistics in 10g and Above (Doc ID 295249.1)

Last updated on SEPTEMBER 20, 2022

Applies to:

Oracle Database - Personal Edition - Version 10.1.0.2 to 11.2.0.2.0 [Release 10.1 to 11.2]
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Oracle Database - Standard Edition - Version 10.1.0.2 to 11.2.0.3 [Release 10.1 to 11.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Purpose

This Note provides information on the how to view details of automated object statistics in Oracle 10g and above

Scope

Users collecting statistics on database objects for use by the Cost Based Optimizer (CBO)

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.