Re: When does LGWR flush the ebuffer?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 23 Apr 2003 00:06:42 +0100
Message-ID: <3ea5cb2a_2@mk-nntp-1.news.uk.worldonline.com>

"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:t42bavcfvnm8gobk6cpobo043lj2ft5n9l_at_4ax.com...
> Now I see why. But is there any type of lock that Oracle places on the
> buffer while redo log is being flush.
> It looks like filling continues while flushing is being done?
>

No. No type of lock. Yes, filling continues, and there is a mechanism to keep it out of the way of unflushed stuff, as of course there must be.

That's the whole point that Richard, Sybrand and the others are making. Oracle *starts* flushing when the redo buffer is one-third full, because the activities which write to it are continuing at the same time.

This is a multi-process, multi-user RDBMS, not a one-job-at-a-time toy.

Regards,
Paul Received on Tue Apr 22 2003 - 18:06:42 CDT