Re: Instance tuning.

On Jun 22, 8:58 am, DA Morgan <damor..._at_psoug.org> wrote:
> 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.
> > 4. Tune contention.
> > 5. Tune the operating system.
>
> Apparently you didn't understand the responses you already received so
> I will try to be as clear as possible.
>
> Nowhere. Your list is meaningless except as an academic exercise and
> as an academic I would give a D to anyone that submitted it.

It is something of a time-warp list. See metalink Note:146560.1 Last update: Jul-6-2001 which is still sitting out there as the FAQ for Database Performance.

>
> Things happen in a specific order.
> Applications are designed ... hopefully well.
>
> Then they are built in accordance with that design and tuned using
> tools such as tracing, profiling, and explain plan.
>
> Then they are evaluated in one or more test environments, unit testing,
> integrated testing, etc. and then deployed into production.
>
> Tuning thereafter should only take place based upon metrics that
> establish a specific cause-effect. Tuning memory or I/O in the
> absence of metrics indicating they are the issue is the cause of
> much wasted effort and often creates new problems that had not
> previously existed.

To the OP: See http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14211/instance_tune.htm to get started, Daniel has succinctly described what is involved. If you are taking some exam, you have to decide whether it is more important to learn to the exam or learn what is real and useful.

jg

--
@home.com is bogus.
http://kevinfu.blogspot.com/