Re: Redo logs and UFS buffering

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/03/27
Message-ID: <38DF60AB.119A@yahoo.com>#1/1

Lee Bennett wrote:
>
> I was once told by a very experienced Oracle DBA that on Solaris will
> switch off any filesystem buffering so that the consistency of the logs
> can be guaranteed. Does anyone know if this is true?
>
> Thanks
>
> LTB
Not Solaris - but Oracle uses a synchronous write call so that it will not proceed until it 'knows' that the data made it to the disk. I'm pretty sure the buffering still occurs, but the the write is guaranteed.

From 2.6, you can have 'forcedirectio' on your file system mounts which avoids the buffering

Or (as I'd recommend for all your files) you can go raw.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Mon Mar 27 2000 - 00:00:00 CST