Database Resident Connection Pool (DRCP) in Autonomous Database supports easier and more efficient management of open connections. Using DRCP provides you with access to a connection pool in your database that enables a significant reduction in key database resources required to support many client connections and when the database needs to scale for many simultaneous connections.
When you connect to Autonomous Database
you choose one of the following depending on values specified in the
tnsnames.ora configuration file:
A dedicated server process, which services only one user process.
A pooled server process, obtained from DRCP, which can service multiple user processes.
To connect with a pooled DRCP server process, do the following:
- Locate or obtain the
tnsnames.orafile you are using to connect to your Autonomous Database.See Download Client Credentials (Wallets) for more information.
- Modify the
tnsnames.orafile to add the server type
example_high= (description= (address=(protocol=tcps)(port=1522)(host=adb.example.oraclecloud.com)) (connect_data=(service_name=example_high.oraclecloud.com)(SERVER=POOLED)) (security=(ssl_server_cert_dn="CN=adb.oraclecloud.com,OU=Oracle US,O=Oracle Corporation,L=Redwood City,ST=California,C=US")))
When you connect with
(SERVER=POOLED)specified in the
tnsnames.orafile you obtain a connection from DRCP.
For Autonomous Database, note the following for working with Database Resident Connection Pools (DRCP):
DRCP is enabled by default; however using DRCP is optional. To choose a pooled connection specify
tnsnames.ora. If you do not specify
SERVER=POOLED, you connect with a dedicated connection.
You cannot start or stop DRCP.
See Using Database Resident Connection Pool for more information.