---
title: "Discussion on \"Automatic maintenance tasks controls the automatic optimizer statistics\" | Hashnode"
description: "Discussion on \"Automatic maintenance tasks controls the automatic optimizer statistics\". Query to check the current state of jobs in CDB_AUTOTASK_CLIENT of the database, auto optimizer stats collection job is disabled in PDBs.\nSELECT \n    COALESCE(p.name, (SELECT name FROM v$database)) AS DATABASE,\n    CASE \n        WHEN c.con_id = 1 THE..."
url: "https://hashnode.com/posts/automatic-maintenance-tasks-controls-the-automatic-optimizer-s/6932ae446aca94d9b033cb1e"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Automatic maintenance tasks controls the automatic optimizer statistics](https://oracledbafindings.hashnode.dev/automatic-maintenance-tasks-controls-the-automatic-optimizer-s?utm_source=hashnode&utm_medium=feed)

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...

Dec 5, 2025 · 4 min read · oracledbafindings.hashnode.dev  
Read the article

-   [#auto-tasks](https://hashnode.com/tag/auto-tasks)
-   [#maintenancewindow](https://hashnode.com/tag/maintenancewindow)

## Written by

[Prasenjit Mahato](https://hashnode.com/@prasenwins)

@prasenwins · Belgium

  
[View profile](https://hashnode.com/@prasenwins)

DBA Behind the Scenes

Oracle DBA

## Responses

Markdown supported · ⌘↵ to post

No responses yet.