Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: System wide slowdown
To reduce the waits on log file sync you need to get in touch with
your sys admin. It involvs improving the performance of log file
writes, say by introducing disc cache, using suitable raid
configurations etc.
As you have an OLTP system, there must be something else also that is generating the redo. Anyway redo can also be generated by table scans. That is called as "Delayed block cleanout".
Pratap Deshmukh
Cognizant Technology Solutions, India
www.Cognizant.com
Received on Thu Aug 12 2004 - 01:01:33 CDT