Re: Buffer Cache, Tuning

I think you are confused on this point, you seem to be referring to the log buffer, not the db cache buffer.

And you missed one: the log buffer is written when it reaches 1 meg, regardless of size of the log buffer.

Jared

On Mon, 1 Nov 2004 16:02:55 +0800, Sinardy Xing <sinardyxing_at_bkgcomsvc.com> wrote:
> Hi all,
> Since DBW will flush buffer cache,
>
> every 3 seconds,
>
> every commit,
>
> when buffer pool 1/3 full
>
> Why we Oracle still need to introduce the DB_BLOCK_MAX_DIRTY_TARGET?
>
> From what I can imagine 3 seconds per flush is reasonably fast.
>
> Sinardy
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l