Automatic maintenance tasks controls the automatic optimizer statistics

Dec 5, 2025 · 4 min read · Query to check the current state of jobs in CDB_AUTOTASK_CLIENT of the database, auto optimizer stats collection job is disabled in PDBs. SELECT COALESCE(p.name, (SELECT name FROM v$database)) AS DATABASE, CASE WHEN c.con_id = 1 THE...