Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Tuning Redo Buffer Cache(RBC)


In order to fine tune the redo buffer cache, execute the following query continuously over a period of time. If the value is increasing steadly, it indicates redo buffer cache is undersized.
sys>select name,value from v$sysstat where name='redo buffer allocation retries';
If the value is increasing, increase the parameter value 'log_buffer'.

Related Posts Plugin for WordPress, Blogger...

Flag Counter