Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition, 2nd Edition
by K Gopalakrishnan
Connection Management
Applications that do not use transaction monitors are generally guilty of poor database connection management. Efficient management of database connections is critical in single-instance databases and in Oracle RAC databases.
Some applications disconnect from the database and then reconnect repeatedly. This is a common problem with stateless middleware applications such as Shell/Perl scripts and precompiler programs that exit on error and tend to use the AUTO_CONNECT option to reestablish the connection. Even in precompiler programs such as Pro*C, application architecture and design would force an unnecessary “connection-disconnection-reconnection” to the database, thus impeding scalability and performance.
Connecting to ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access