Re: Some tuning advise

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 23 Oct 2007 21:37:44 +0200
Message-ID: <fflii7$7k2$1@news2.zwoll1.ov.home.nl>

joel garry wrote:
> I'm with Ian - 4GB with db_block_buffers=2000? Red flag, not
> obsessiveness. In general, reviewing things that obviously haven't
> been tuned is not obsessive. Periodically reveiwing isn't obsessive.

No, I agree on that - but there is no indication in the original post as to why:

* No user complaints
* No mention of reports all of a sudden taking 10 times longer,
* nor any screens,
* nor any other query

And why would db_block_buffers = 2000, in combination with 4GB memory on the machine raise a flag?

Lots of assumptions here...

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

Received on Tue Oct 23 2007 - 14:37:44 CDT