Wednesday, October 28, 2009

DRCP vs Oracle Shared Server

While i was hanging out in the Oracle Database 11g New Features documents on OTN I found something interesting which is not documented on Oracle 11g New Features, Database Resident Connection Pooling (DRCP). I was surprised because this feature is very handy and usable in a lot of environment especially if you serve your data to more than one application running on more than one application server and with enormous number of connections.

Before Oracle Database 11g we were all using Oracle Shared Server architecture to lower the server side user processes and their overheads to the server resources. But with 11g the similar architecture is available now called Database Resident Connection Pooling (DRCP).

Quoted from the related document linked at the end of the this post:

"In one of our test scenarios on a 2GB system, DRCP was able to support 10 times the number of connections compared to shared servers, and 20 times the number of connections compared to dedicated servers."

The question; is DRCP a replacement of Oracle Shared Server?

Database Resident Connection Pooling (DRCP) Oracle Database 11g Technical White Paper

1 comment:

  1. DreamHost is one of the best web-hosting company with plans for any hosting requirments.