Use Database Resident Connection Pooling with Autonomous Database
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:
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
SERVER=POOLED
intnsnames.ora
. If you do not specifySERVER=POOLED
, you connect with a dedicated connection. -
You cannot start or stop DRCP.
See Using Database Resident Connection Pool for more information.
Parent topic: Connection and Networking Options and Features