Re: Data Buffer Cache

From: Nuno Souto <nsouto_at_optushome.com.au>
Date: 15 Sep 2002 21:49:31 -0700
Message-ID: <dd5cc559.0209152049.43a01401@posting.google.com>

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<3d84e994_at_dnews.tpgi.com.au>...

> accuracy of the information that was being quoted that's stuffed. If this
> was really the way that things happened, the database would grind to a halt
> at every log switch, waiting for DBWR to do its thing, and Oracle would have
> about 0.2% marketshare as a result.
>

Er.......

Major rule of performance benchmarks for Oracle: make the redo logs so large you hardly ever get a log switch and its consequent checkpoint. Or at least you get so few you can easily include its overhead in the dead periods between "measurement" periods.

<g, d&r>
Cheers
Nuno Souto
nsouto_at_optushome.com.au Received on Sun Sep 15 2002 - 23:49:31 CDT