Skip to Main Content

Feature Details

Buttons

Feature Details Container

AUTOTASK_MAX_ACTIVE_PDBS Initialization Parameter

Database Overall → Pluggable Databases

The AUTOTASK_MAX_ACTIVE_PDBS initialization parameter enables you to specify the maximum number of pluggable databases (PDBs) that can schedule automated maintenance tasks at the same time (during a maintenance window).

Release Availability
11.2
12.1
12.2
18c
19c
21c
23ai
Licensed With
Oracle Multitenant
Available On
  • Oracle Database FREE
  • Enterprise Edition
  • Oracle Database Appliance
  • Exadata
  • Exadata Database Service on Dedicated Infrastructure / Cloud@Customer
  • Database Cloud Service Enterprise Edition - High Performance
  • Database Cloud Service Enterprise Edition - Extreme Performance

Notes:

For all offerings using Oracle Database 19c or later, if you are not licensed for Oracle Multitenant, then you may have up to 3 user-created PDBs in a given container database at any time.

For all offerings using Oracle Database 12.1 through 18c, if you are not licensed for Oracle Multitenant, then the container database architecture is available in single-tenant mode, that is, with one user-created PDB, one user-created application root, and one user-created proxy PDB.

The following policies apply to all Oracle Database releases that support Oracle Multitenant (Oracle Database 12.1 and later):

  • Free: Included option; you are licensed to create up to 16 PDBs, however, the actual number of PDBs you can create might be less due to Free resource limits.
  • EE: Extra cost option; if you are licensed for Oracle Multitenant, then you can create up to 252 PDBs.
  • ODA and Exa: Extra cost option; if you are licensed for Oracle Multitenant, then you can create up to 4096 PDBs.
  • ExaDB/CC, BaseDB EE-HP, and BaseDB EE-EP: License included option: You can create up to 4096 PDBs. BYOL option: Limit is 3 PDBs, unless you purchase the Oracle Multitenant option.

Authorized Cloud Environments: Use is limited to three pluggable databases per container database.

Initial Release
12.2.0.1