Re: Data Buffer Cache

I also tell them of the database in Queensland that produces a 500M archive every 7 minutes.

I flatter myself that people don't come out of the classroom until they've got as a complete a picture as it's possible to paint in the time allowed. If you have to switch that frequently, so be it. Just be aware of the costs involved. And if you can avoid switching that frequently, it's generally a good idea to do so, bearing in mind the further potential costs in instance recovery scenarios.

The bottom line I give them is: size your logs so that you end up switching (and hence checkpointing) at a rate you are happy with.

Regards
HJR "Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:t2oeouk7kk8kugc5m2b3c4vlij4jipr61a_at_4ax.com...
> On Tue, 17 Sep 2002 19:12:01 +1000, "Howard J. Rogers"
> <howardjr2000_at_yahoo.com.au> wrote:
>
> >I also tell them of the 'one switch per hour' school of DBAing, so they
get
> >both sides.
>
> So what if you often have 250M redolog in less than 30 minutes?
> (I'm not joking)
>
>
> Regards
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Tue Sep 17 2002 - 15:01:20 CDT