Buffer Cache Hit Ratio

Solution

By itself, the buffer cache hit ratio is not very meaningful except for databases with undersized data buffer cache (db_cache_size parameter).

Oracle provides the data buffer cache advisory utility v$db_cache_advice for assistance with sizing.


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *