My Oracle Support Banner

FAQ: Gathering Concurrent Statistics Using DBMS_STATS Frequently Asked Questions (Doc ID 1555451.1)

Last updated on DECEMBER 07, 2024

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.

Purpose

This document covers many of the frequently asked questions about gathering concurrent statistics using DBMS_STATS.

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
 Concurrent Statistics Gathering
 What is Concurrent statistics gathering?
 If Concurrent Statistics is controlled via the job_queue_processes parameter, the default in 11.2.0.3.0 is 1000. Would a stats gather job really create 1000 concurrent stats gather processes?
 How can I check the current setting?
 How do I control how many jobs get created using Concurrent Statistics with auto optimizer stats collection?
 How is gathering concurrently different from parallel stats gathering ?
 Does gathering statistics concurrently interfere with parallel stats gathering ?
 Is concurrent object stats gathering automatic or is it parameter controlled ?
 What changes have occurred 12.1 and higher?
References

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