Re: When does LGWR flush the ebuffer?

On Tue, 22 Apr 2003 22:34:19 GMT, "Ryan" <rgaffuri_at_cox.net> wrote:

>
>"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?
>

A logswitch also causes a checkpoint. Received on Wed Apr 23 2003 - 03:45:55 CDT