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:

  1. Locate or obtain the tnsnames.ora file you are using to connect to your Autonomous Database.
    See Download Client Credentials (Wallets) for more information.
  2. Modify the tnsnames.ora file to add the server type SERVER=POOLED.

    For example:

    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_dn_match=yes)))

    When you connect with (SERVER=POOLED) specified in the tnsnames.ora file 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 SERVER=POOLED in 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.