Re: oracle performance

From: Jim Kennedy <jim>
Date: Tue, 31 Oct 2006 18:32:21 -0800
Message-ID: <ntSdnWyODK_Gm9XYnZ2dnUVZ_uudnZ2d@comcast.com>

"rawass" <wassim_najjar_at_cis.com.lb> wrote in message news:1162027422.196530.274480_at_k70g2000cwa.googlegroups.com...
> Dear All,
>
> I need to know what are in general the steps that I have to follow in
> order to diagnose the reasons behind a performance problem on oracle
> dtabases? Please if you can detail each step in your answer.
>
> Best Regards
>

There are only 2 reasons.
1. You are trying to use too much of a resource. 2. You are serialized on a resource.

The answers are:
For #1 use less of the bottlenecked resource (eg don't do work you don't need to do)
For #2 Fix the application so you are not serialized on the resource. (eg latching, esp. no bind variables) Received on Tue Oct 31 2006 - 20:32:21 CST