Database Administration (MOSC)

MOSC Banner

Gather Stats not collected for few tables

Hi Team,

Our DB version 19.28

CDB with single PDB.

We observed stats are not gathered for few tables. This is a new database. By default, stats will be enabled. Please correct me if wrong.

SQL> SELECT CLIENT_NAME, STATUS
FROM DBA_AUTOTASK_CLIENT
WHERE CLIENT_NAME = 'auto optimizer stats collection'; 2 3

CLIENT_NAME STATUS

auto optimizer stats collection ENABLED

SQL> SELECT LAST_START_DATE
FROM DBA_SCHEDULER_JOBS
WHERE job_name='GATHER_STATS_JOB'; 2 3

no rows selected

SQL>

TABLE_NAME LAST_ANALYZED

XXTTD_AR_DCB_READINGS_STG_TBL 31-OCT-25
XXTTD_AR_DCB_CNV_STG_TBL 31-OCT-25
XXTTD_AR_DCB_PROPS_HDR_TBL 31-OCT-25

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center