Database Resident Connection Pooling is a new feature of Oracle
Database 11g. It is useful for short lived scripts such as typically
used by web applications. It allows the number of connections to be
scaled as web site usage grows. It allows multiple Apache processes on
multiple machines to share a small pool of database server processes.
Without DRCP, a Python connection must start and terminate a server
process.
Below left is diagram of nonpooling. Every script has its own
database server proces. Scripts not doing any database work still hold
onto a connection until the connection is closed and the server is
terminated. Below right is a diagram with DRCP. Scripts can use database
servers from a pool of servers and return them when no longer needed.
No comments:
Post a Comment