Chapter 19. Workload Management

In this chapter, we discuss workload management for RAC databases. We first examine the available methods to distribute workloads across the different nodes of a cluster, and then we describe the use of database services to manage the workload across a RAC database. Database services provide a powerful mechanism with which you can visualize and control demand for resources across the entire cluster.

Workload Distribution

In a cluster consisting of two or more nodes, it is necessary to have a method for distributing the workload across the nodes to maximize scalability and throughput. Workload distribution is also desirable from an availability point of view, to minimize the effect of individual node failures on overall ...

Get Pro Ora cle Database 10g RAC on Linux Installation, Administration, and Performance 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.