My Oracle Support Banner

HS: [OCI BACKPLANE] Auto Gather Stats Not Working (Doc ID 2814269.1)

Last updated on OCTOBER 19, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 18.9.0.0.0 [Release 12.1 to 18]
Information in this document applies to any platform.

Symptoms

A scheduled job, "auto optimizer stats collection" does not run when it is expected to run.

Select c.name as pdb_name, t.* from cdb_autotask_client t, v$containers c

  where c.con_id = t.con_id order by c.name, t.client_name

shows

_system_trig_enabled is set to TRUE

 

The view sys.scheduler$_Window_refresh exists in the PDB. (If it does not you should run catschv.sql in the PDB).

 

Changes

 No changes were made.

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.