Re: System wide slowdown

From: Pratap <pratap_fin_at_rediffmail.com>
Date: 11 Aug 2004 23:01:33 -0700
Message-ID: <830861d2.0408112201.3108f445@posting.google.com>

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