2.124 ENABLE_PER_PDB_DRCP
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:
-
true
DRCP 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_OPT
initialization parameters for a PDB, and you can use theDBMS_CONNECTION_POOL
package to manage the connection pool for a PDB.When
ENABLE_PER_PDB_DRCP
is set totrue
, there is no connection pool for the entire CDB. The values of theMIN_AUTH_SERVERS
,MAX_AUTH_SERVERS
, andDRCP_DEDICATED_OPT
initialization parameters have no meaning in the CDB root and you cannot alter them, nor can you use theDBMS_CONNECTION_POOL
package while connected to the CDB root. -
false
DRCP 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_OPT
initialization parameters only in the CDB root, and you can use theDBMS_CONNECTION_POOL
only while connected to the CDB root.
Note:
This parameter is available starting with Oracle Database 21c.
See Also:
-
Oracle Database PL/SQL Packages and Types Reference for more information on the
DBMS_CONNECTION_POOL
package