Contents Lab128 - Tools for Advanced Oracler Tuning and Monitoring. Reference Guide.

Ratio RAC, Local Cache Buffer Access


Local Cache Buffer Access Ratio - percentage of blocks satisfied from local cache to the total number of blocks requested by sessions. In OLTP applications it is desirable to maintain this ratio as high as possible because this is the least expensive and fastest way to get the database block.

This ration is calculcated as:

Local Cache Buffer Access Ratio = 1 - ( physical reads cache + Global Cache blocks received ) / Logical Reads


Note. Please note, that this ratio has exactly same definition and meaning as the Buffer Hit Ratio for non-RAC instance.