Re: How to tune Oracle database 10.1.0.3.0 on slow performance
Date: Wed, 9 Jan 2008 04:59:19 -0800 (PST)
On Jan 9, 3:33 am, pejantan4u <pejanta..._at_gmail.com> wrote:
> Hi all,
> we're running Oracle 10.1.0.3.0 on Linux Redhat ES 4, 12GB memory.
> we are testing application with 50user+ that connect into the database
> oracle 10.1.0.3.0 and i saw graphic performance on my EM, it looks ok.
> and then on top sql, few queries showed percentage 44% and 60%, i
> tried to run the sql tuning advisor but oracle only recomend gather
> statistic, but i think this wasn't enough. what should i do ? could
> anyone help me
> and in this case of situation, what kind of tuning method that you
> guys recomend, and how the solution beside using ADDM, coz i have
> tried to use ADDM and i still couldn't find the solution
"we're running Oracle 10.1.0.3.0"
I'd start with applying the latest patchset and critical patch updates and then start investigating performance issues (through your regular testing environment, of course).
-bdbafh Received on Wed Jan 09 2008 - 06:59:19 CST