Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Instance tuning
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.
-- http://www.mladen-gogala.comReceived on Fri Jun 22 2007 - 15:47:58 CDT