Re: lgwr performing direct i/o on unix platforms?

From: Antoine BRUNEL <antoinebrunel_at_nospam_yahoo.fr>
Date: Wed, 19 Jan 2005 23:51:04 +0100
Message-ID: <41eee458$0$22615$79c14f64@nan-newsreader-06.noos.net>

Hi from Paris

"Frank" <no_at_spam.org> a écrit dans le message de news: 41eedefa$0$6208$e4fe514c_at_news.xs4all.nl...
> Hello,
>
> a question recently came to my mind: is the lgwr process performing direct
> I/O on writing the redo logs on disk (direct i/o = no filesystem cache is
> used)? In other words, is it using a write-through-cache when writing the
> redo's on disk? On the unix platform it is.
>
> Regards,
> Frank

Although you can control the database access for DBFILES, through the filesystemio_option parameters, redo logs are always wrote using O_DIRECT parameters.... this way, Oracle guarantee commited transactions would be recoverable in case of instance crash... Received on Wed Jan 19 2005 - 16:51:04 CST