Optimizing the performance of the redo log buffer
SELECT NAME, VALUE
FROM V$SYSSTAT
WHERE NAME = 'redo buffer allocation retries';
This value should remain close to zero over an interval of typical activity on the system. If it increments, increase the initialization parameter LOG_BUFFER. You can also improve redo performance by making sure that the redo log files reside on fast disks with no I/O taking place on them other than the LGWR writes.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments