My Oracle Support Banner

GATHER_STATS_JOB Does Not Run when Run using OEM Database Control (Doc ID 428252.1)

Last updated on JULY 08, 2021

Applies to:

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

Symptoms

When trying to execute the GATHER_STATS_JOB through Oracle Enterprise Manager Database Control, 

OEM refreshes the window and indicates that the job is submitted. But in the current execution or history tab,

there is no entry for the Job. Job seems to be not executed. 

Note: - GATHER_STATS_JOB in 10g captures the database statistics and is scheduled to run during maintenance window. 

This note discusses the issue when you try to gather the database statistics immediately using OEM database control and the job does not run.

 

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
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.