Re: When does LGWR flush the ebuffer?

From: Ryan <rgaffuri_at_cox.net>
Date: Tue, 22 Apr 2003 22:34:19 GMT
Message-ID: <Lrjpa.149613$yh1.9548056@news1.east.cox.net>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:a20d28ee.0304220547.56267e8c_at_posting.google.com...
> Peter <peter_at_nomorenewsspammin.ca> wrote in message
news:<kur9avoueoqsaaepunact06qcraj7vla7o_at_4ax.com>...
> > The LGWR flushes the buffer every 3 seconds, or when there is a
> > commit.
> > Does it ever flush it when the buffer is 1/3 or totally full?
> > If it flushes it when buffer 1/3 full, then it will never get filled
> > up?
>
> It flushes at 1/3 or 1M, whichever comes first.
> Hence if it does get filled up, it means LGWR is incapable to process
> the load you are forcing it to swallow.
>
> Regards
>
> Sybrand Bakker
> Senior Oracle DBA

someone on a listserv I get posted that when you issue a commit DBWR activates and writes to disk. Is this accurate? I thought DBWR was only flagged and that a checkpoint determined when it was written to the datafile because its more costly to write to a datafile then to a redo log? Received on Tue Apr 22 2003 - 17:34:19 CDT