My Oracle Support Banner

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

Last updated on APRIL 06, 2022

Applies to:

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


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.



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

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