Oracle 参数 ENABLE_PER_PDB_DRCP 官方解释，作用，如何配置最优化建议
本站中文解释
ENABLE_PER_PDB_DRCP参数用于指定用于特定上下文的单一子进程协议（DRCP）. 此设置适用于用于常规连接的PDB_DRCP参数.
定义：
ENABLE_PER_PDB_DRCP参数是 Boolean 类型参数，生效时间是重新启动数据库（或更改参数）后。
有效值：
TRUE 在这种情况下， DRCP 将启用 PDB-specific 会话，并特定于上下文。
FALSE 在这种情况下，DRCP 将根据库中定义的唯一实例使用如果适用 PDBC_DRCP 参数。
默认值：
该参数的默认值是 FALSE。
正确设置：
正确设置ENABLE_PER_PDB_DRCP参数的首先步骤是确定数据库实例是否使用DRCP协议。要确定此参数，请使用 PROCEDURE DBMS_DRCP.CONFIGURE_PDBC_DRCP(DRCP_ENABLED => TRUE) 将 DRCP_ENABLED 设置为 TRUE 。然后，可以根据需要设置 ENABLE_PER_PDB_DRCP 参数。
要完成正确的设置，可以使用以下SQL语句：
ALTER SYSTEM SET ENABLE_PER_PDB_DRCP=TRUE SCOPE=SPFILE;
官方英文解释
ENABLE_PER_PDB_DRCP controls whether Database Resident Connection Pooling (DRCP) configures one connection pool for the entire CDB or one isolated connection pool for each PDB.
| Property | Description |
|---|---|
|
Parameter type |
Boolean |
|
Default value |
|
|
Modifiable |
No |
|
Modifiable in a PDB |
No |
|
Range of values |
|
|
Basic |
No |
|
Oracle RAC |
Multiple instances must have the same value. |
Possible values:
-
trueDRCP creates one isolated connection pool for each PDB. You can connect to a particular PDB and configure, manage, and monitor its connection pool according to the specific requirements for that PDB. For example, you can set values for the
MIN_AUTH_SERVERS,MAX_AUTH_SERVERS, andDRCP_DEDICATED_OPTinitialization parameters for a PDB, and you can use theDBMS_CONNECTION_POOLpackage to manage the connection pool for a PDB.When
ENABLE_PER_PDB_DRCPis set totrue, there is no connection pool for the entire CDB. The values of theMIN_AUTH_SERVERS,MAX_AUTH_SERVERS, andDRCP_DEDICATED_OPTinitialization parameters have no meaning in the CDB root and you cannot alter them, nor can you use theDBMS_CONNECTION_POOLpackage while connected to the CDB root. -
falseDRCP creates one connection pool for the entire CDB. This connection pool is shared by all PDBs. You can set the
MIN_AUTH_SERVERS,MAX_AUTH_SERVERS, andDRCP_DEDICATED_OPTinitialization parameters only in the CDB root, and you can use theDBMS_CONNECTION_POOLonly while connected to the CDB root.
Note:
This parameter is available starting with Oracle Database 21c.
See Also:
-
“MIN_AUTH_SERVERS”
-
“MAX_AUTH_SERVERS”
-
“DRCP_DEDICATED_OPT”
-
Oracle Database PL/SQL
Packages and Types Reference for more information on theDBMS_CONNECTION_POOLpackage
