Re: Redo Log question

On 22 Jan 1996, Parris Geiser wrote:

> Hi,
> Our application has peak periods of heavy updates. During that time
> a large number of redo logs are generated. The cpu for writing
> these logs takes away from processing and reduces the thruput.
> Currently we have 3 logs of 10Megs. The question is:
> would it be better to have fewer smaller logs, e.g., 10 each 1M.
> Or, increase the size of the log file to handle the peak period
> within one log file, e.g., 3 logs of 50M?
>
> Thanks for any info.
> parris

        Neither case will increase the speed visibly. We have two redo 
        logs of 367M each. The problem continues to keep those redo logs 
        alive. To maintain them is the main problem. But if you really 
        want to try changing the size, be careful to set a good size for 
        your database, it may not be possible to set smaller values and 
	get the same performance. 

 	My overall advice (as a UNIX programmer, not Oracle DBA) is,
	keep them as they are. 3x10M is not a big size. 

        Murat


	Murat Cakir
	UNIX Programmer
	METU-CC Turkiye