Re: Synchronous writes & TEMP

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 15 May 2004 08:42:43 +0000 (UTC)
Message-ID: <c84l63$5no$1@titan.btinternet.com>

I believe that the writes are still buffered, even when they are ODSYNC writes. They still go into (straight through and out the either side of) the file system cache. Many operating systems have a 'directio' (or similar) option to bypass the file system buffer cache.

(That's not intended to be an answer to your question, by the way).

Maybe there's something in parameter

filesystemio_options
that can be used to modify the default
behaviour.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated May 1st


"VC" <boston103_at_hotmail.com> wrote in message
news:kmfpc.51622$xw3.3121273_at_attbi_s04...


> Sorry,  the previous message is incorrect:

>

> This:

>

> "Now,  the original question remains: why does Oracle use synchronous

(also


> known as 'delayed') writes ?"

>

> ... should read as:

>

> "Now,  the original question remains: why does Oracle use synchronous

> instead of buffered (also known as 'delayed') writes ?"

>

> Regards.

>

> VC

>

>

Received on Sat May 15 2004 - 03:42:43 CDT