CHAPTER 13Workload and Connection Management

The fundamental features of a good, scalable database management system include connection and workload balancing of database connections. Efficient management of these connections, once established, is very important, especially for providing database as a service for big enterprise applications. Fault-tolerant services must be provided by the database engine so that users can take appropriate actions as alternatives to failures and errors.

In a large installation, potentially thousands of users could log on or off from a database within a short span of time. An efficient database engine ensures minimal delays in processing their requests and managing the resources used by these connections. Complex ...

Get Oracle Database 11g Oracle Real Application Clusters Handbook, 2nd Edition, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.