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

Note:

This initialization parameter is available starting with Oracle Database 12c Release 2 (12.2.0.1).

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 Database Administrator’s Guide for more information about managing automated database maintenance tasks