| Oracle RAC Performance and Tuning specially gc cr multi block request wait event |
|
| This article is for advance RAC DBA which covers Oracle 9i RAC,Oracle 10g RAC,Oracle 11g RAC.It covers Tuning of Wait event called "gc cr multi block read" , Global Cache Services and Cache Fusion of Oracle Real Application Cluster.
|
|
| How to tune "global cache services" and "gc cr multi block request" wait event? |
|
| LMS process called as Lock Manager Server Process , also called the GCS (Global Cache Services) process. Main work of this process is to transport blocks across to the nodes of Oracle RAC for ?cache fusion? supportation. If any consistent read request found from another connected node then LMS process makes consistent read image of block and transport it to across the nodes for full feelling client?s consistent read request. This images trasnports using High Speed Interconnet process to and from remote nodes.
|
|
| Multi block read called as full table scan and it uses multiple blocks and mode large read request. While during cache fusion, a global cache service makes same blocks to consitent read images and transport same blocks to remote node across Oracle Real Application Clusters (RAC).
|
|
| Wait event "gc cr multi block request" reflects problem of transporting data across to nodes in cluster specially when found mode CPU consume and mode network busy during operations.
|
|
| For more details kindly download document called "Perfomance and Tuning of Oracle RAC databases-1" from our website as per following link.
|
|
|
http://www.dbametrix.com/download_info.php
|
|
|
