Oracle 参数 MAX_DATAPUMP_JOBS_PER_PDB 官方解释，作用，如何配置最优化建议
本站中文解释
MAX_DATAPUMP_JOBS_PER_PDB 是Oracle Database 11gR2引入的参数，用于控制数据库中Data Pump操作所能同时运行的最大数量。参数值默认为4，它针对每个PDB而言，作用于PDB层次。可以通过修改参数值来提高Data Pump操作的最大同时运行量，以提高数据的传输速率。 正确设置MAX_DATAPUMP_JOBS_PER_PDB的方法：
1、 在Oracle数据库中，以sysdba身份登录。
2、 执行以下SQL：
ALTER system SET MAX_DATAPUMP_JOBS_PER_PDB=8 scope=both;
3、 使配置生效：
commit;
4、 重新关闭数据库并启动。
官方英文解释
MAX_DATAPUMP_JOBS_PER_PDB determines the maximum number of concurrent Oracle Data Pump jobs per PDB.
| Property | Description |
|---|---|
|
Parameter type |
String |
|
Syntax |
|
|
Default value |
100 |
|
Modifiable |
|
|
Modifiable in a PDB |
Yes |
|
Range of values |
|
|
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.
When this parameter has a value of AUTO, Oracle Data Pump will derive its actual value to be 50% of the SESSIONS initialization parameter.
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.
See Also:
-
Oracle Database
Utilities for more information about using Oracle Data Pump with CDBs -
Oracle Database PL/SQL
Packages and Types Reference for more information about theDBMS_DATAPUMPPL/SQL package
