Folks, I have a serious problem in production machine- as it became too slow and I found out there is contention in LGWR.
DataFile Name Result
---------------------------------------- ---------------
redo log space requests 2,017
It has to be around 0, so please advice me . My current log_buffer parameter in init.ora is 10MB and I have 5 redo log groups of 512 KB each.Oracle 9i rel2 on Windows.
If I increase the logbuffer and rebounce db is it going to solve, wondering more than 10MB will actually benefit or not?
Thanks