My Oracle Support Banner

Optimizer Statistics History Information Become Huge due to Automatic Statistics Gathering Job Run Multi Times in One Maintenance Window (Doc ID 2501155.1)

Last updated on APRIL 09, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

 

 

Note:

This issue also have another symptom like the below issue occurs every 10 minutes in maintenance window.

<Document 2127675.1> ORA-12012 Error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_<NN> in 12.2.0 Database version or higher release (like 18c) 

Changes

 Update to 12.2.

Cause

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
Symptoms
Changes
Cause
Solution
References


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