Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 









Enabling and Monitoring DRCP in 11g

Oracle 11g New Features Tips by Donald BurlesonJune 29, 2015

Oracle 11g New Features Tips

In order to enable DRCP, the connection broker needs to be started.  The following command starts the broker, which registers itself with the database listener from sys user :

SQL> execute dbms_connection_pool.start_pool(); 

Once the pool is started, it remains in this state until it is explicitly stopped.  The pool is automatically restarted if it is active when the database instance is restarted. 

In order for the client connections to use the connection pool, the connect string must specify the connect type as POOLED.  For example, the TNS connect descriptor to use DRCP for client connections could be:


The DRCP pool can be stopped when all client requests managed by DRCP have completed using the following command from sys user:

SQL> execute dbms_connection_pool.stop_pool(); 

Considerations with DRCP

Since the pooled servers are essentially a pool of preserved dedicated servers, there are certain special considerations that apply to the use of DRCP in the database:

  • Modifying database users of DRCP - Since pooled servers are dedicated servers owned by the user, it is not possible to change the password of a user while that user is connected.  Also, when dropping a user, make sure that no sessions authenticated by that user are in the pool.

  • Shutting down the database - When client connections are actively being handled by DRCP, the database needs to wait until all pooled servers are returned to the connection broker before stopping the pool and shutting down the database. 

  • Advanced Security Option (ASO) - ASO options are not available for pooled servers. 

Monitoring DRCP

Oracle 11g has provided several dynamic views for monitoring database resident connection pooling including:

  • dba_cpool_info - Contains information about the connection pool including the maximum and minimum number of connections, pool status, and timeout for idle sessions.

  • v$cpool_stats - Contains pool statistics including the number of session requests, the total wait time for a session request, and the number of times a session that matches the request was found in the pool.

  • v$cpool_cc_stats - Contains connection-class level statistics for the pool.


This is an excerpt from the new book Oracle 11g New Features: Expert Guide to the Important New Features by John Garmany, Steve Karam, Lutz Hartmann, V. J. Jain, Brian Carr.

You can buy it direct from the publisher for 30% off.


Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.