Re: Enterprise slow, Standard fast?

On Sun, 07 Nov 2004 20:38:32 +0200, Arska wrote:

> Now we need to tune every job again, parallel execution in mind. Or deny
> parallel execution for these jobs. (How?)

No! You should just tune the buffer cache hit ratio. When it is close to 100%, your performance is good. Make sure that BCHR reports are compiled and run every morning. The job of a DBA is to maintain the highest cache hit ratio possible. DBAs are the priests of the buffer cache god. You shouldn't be tuning applications, but the instance. Users are not running applications, they're running instance, so that's what you tune. That means that all you have to do is to fiddle and twist the buffer cache parameters and everything will be good. Make sure that 99% of cache hit ratio is entered into the official company documentation as the ultimate performance metrics.

-- 
Artificial Intelligence is no match for natural stupidity.