Re: Instance tuning

On Fri, 22 Jun 2007 20:47:58 GMT, Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net> wrote:

>On Thu, 21 Jun 2007 09:48:21 -0700, sd2611 wrote:
>
>> Where does the instance tuning fit if we use the below-mentioned order
>> implementation.
>> 1. Tune the design.
>> 2.Tune the application.
>> 3. Tune memory.
>> 4. Tune I/O.
>> 5. Tune contention.
>> 6. Tune the operating system.
>
>It doesn't fit. One never tunes instance, I/O contention or the OS. One
>can only tune the application. One does that by adjusting application,
>instance parameters, OS parameters and all the rest, as needed.
>Instance without application system running against it never needs
>tuning.

Usually one can't tune the application as it has been developed by an ISV and they don't know how to tune.
This is the point where the Burlesons and Aults of this world come in, and start throwing iron at the problem.

-- 
Sybrand Bakker
Senior Oracle DBA