Hello;
Try to reduce the buffer_cache in pieces of 5%;
Then monitor the BufferCachce-Hit-Ratio over a longer period
if it's in summary still over 95% then you can reduce again.
This you can do in production-environment.
Orca
|
Results 1 to 9 of 9
Thread: Buffer Cache TuningThreaded View
|
Click Here to Expand Forum to Full Width |