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.




Oracle Wait Interface
Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning (Osborne ORACLE Press Series)
ISBN: 007222729X
EAN: 2147483647
Year: 2004
Pages: 114

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net