Re: When does LGWR flush the ebuffer?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 22 Apr 2003 06:47:49 -0700
Message-ID: <a20d28ee.0304220547.56267e8c@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 Received on Tue Apr 22 2003 - 08:47:49 CDT