My Oracle Support Banner

Adaptive Dynamic Statistics (Doc ID 2002108.1)

Last updated on MARCH 18, 2022

Applies to:

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

Purpose

Outline the introduction of Adaptive Dynamic Statistics (ADS) in Oracle Database 12c Release 1 (12.1)

Scope

This information is suitable for a variety of audiences interested in query optimization

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!

In this Document
Purpose
Scope
Details
 Enabling Adaptive Dynamic Statistics
 Triggering Adaptive Dynamic Statistics during Adaptive Query Optimization
 Disabling Dynamic Statistics
 Parameter example
 Hint example
 Note for ADS and Sql Plan Directives
References


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