My Oracle Support Banner

Statistics (Cardinality) Feedback - Frequently Asked Questions (Doc ID 1344937.1)

Last updated on DECEMBER 30, 2024

Applies to:

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

Purpose


This document records a number of Frequently Asked Questions pertaining to the tuning of SQL statements with the Statistics Feedback (formerly known as Cardinality Feedback) feature.

Scope & Application

DBAs and Support Engineers

Questions and Answers

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
Questions and Answers
 What is Statistics Feedback?
 How does Statistics Feedback work?
 How is Statistics Feedback enabled?
 How can Statistics Feedback be disabled?
 Is Statistics Feedback persistent when the cursor is aged out?
 How can we determine that Statistics Feedback was used?
 What is the relationship between Statistics Feedback and USE_FEEDBACK_STATS in V$SQL_SHARED_CURSOR?
 Under what conditions is Statistics Feedback considered?

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