1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. MAX_DATAPUMP_JOBS_PER_PDB

1.176 MAX_DATAPUMP_JOBS_PER_PDB

MAX_DATAPUMP_JOBS_PER_PDB determines the maximum number of concurrent Oracle Data Pump jobs per PDB.

Property Description

Parameter type

Integer

Default value

100

Modifiable

ALTER SYSTEM

Modifiable in a PDB

Yes

Range of values

0 to 2147483647

Basic

No

Oracle RAC

The same value must be used on all instances.

The default value will not work for all databases. Database administrators will have to determine if the default value works well for their database.

A value that is too large could cause Oracle Data Pump to consume too many system resources, while a value that is too small could prevent users from performing their Oracle Data Pump tasks.

The main resource Oracle Data Pump uses is shared pool in the System Global Area (SGA) for the database. Parallel jobs increase the number of sessions and, depending on the job, the number of PQ slaves used.

Note:

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

See Also: