Need help understanding a performance problem

Morning Harry,

>> Ah, but I could be persuaded to become a Bakkerite, were I only given
words
>> of wisdom!!

What Sybrand is alluding to is the fact that Rich N and Don B are disciples of 'ratio based tuning' whereby the database *must* be running efficiently if you have a 100% (or close to it) buffer cach hit ratio. The fact that Oracle tuning courses teach this as well may have a lot to do with it.

The rest of the world have long since realised that ratios are a waste of time. You can even get a script from Connor McDonald's web site (when it comes back online - he has moved back to Australia) which asks for a required ratio and with nothing more than a few full table scans manages to increase the hit ratio to the requested value or higher. Hencve, according to Ricn N or Don B, the database is fully tuned. (Not !)

>> IOW, in all seriousness, what's the problem with the increase in
>> db_block_buffers?

Nothing - provided you don't exceed the point where returns are minimal. But don't beleiev that the Hit Ratio being > 90% indicates a tuned database :o)

Cheers,
Norman.

PS. Jitandra Patel is a troll from (I suspect the DB2 news groups) who takes great delight in slagging off anyone he feels like. I've been on the receiving end myself, but he vanished when I pointed out a few home truths in his waffle. Best avoided. He has little or no knowlege of Oracle (like my knowlede of DB2) and is best ignored. He also has a couple of buddies who back him up from time to time. Received on Tue Jul 22 2003 - 04:16:22 CDT