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