In a Nutshell

Real Application Clusters waits are a special case in the Oracle Database environment because of the multiple instances accessing the same set of resources. Everything you learned about wait events in the single instance environment is applicable to the RAC environment as well. In RAC environment you must know about global cache cr request, global cache busy, and enqueue wait events.

This chapter introduces you to the global cache management and the implementation of global cache in Real Application Clusters. Understanding RAC related wait events helps you diagnose the problems in these environments so you can zero in on the solution.

Get Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning 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.