AUTOTASK_MAX_ACTIVE_PDBS
AUTOTASK_MAX_ACTIVE_PDBS enables you to specify the maximum number of PDBs that can schedule automated maintenance tasks at the same time (during a maintenance window).
| Property | Description |
|---|---|
| Parameter type | Integer |
| Default value | 2 |
| Modifiable | ALTER SYSTEM |
| Modifiable in a PDB | No |
| Range of values | 0 to the number of PDBs in the CDB |
| Basic | No |
| Oracle RAC | The same value should be used on all instances. |
This parameter only affects PDBs. The CDB$ROOT container (CDB root) for a CDB can always schedule and run maintenance tasks during a maintenance window.
The default value is 2. Therefore, by default, two PDBs and the CDB root can run tasks at the same time during a maintenance window.
This parameter can be set only in the CDB root, not in a PDB.
See Also:
-
“ENABLE_AUTOMATIC_MAINTENANCE_PDB” for information on disabling or enabling the running of automated maintenance tasks for specific PDBs or for all the PDBs in CDB
-
Oracle AI Database Administrator’s Guide for more information about managing automated database maintenance tasks