Re: Oracle slowed down

> I think they did. If you look at Buffer Cache Size Advice, you'll
> notice they say "Relative Change in Physical Reads."

Even this is still akin to the BCHR. Increasing or decreasing your buffer cache will make changes to the physical reads required to satisfy your "normal" workload. But is this really that different than tuning by the BCHR? So I decreased by physical reads by 10%. Is that good? It may or may not be. In some cases, I still have poorly written SQL which needs to be tuned. Tuning that SQL can reduce the physical reads as well. Sizing the buffer cache to reduce the physical reads, is the same (in my book) as sizing the buffer cache to increase the BCHR.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
oracle_dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown