Re: How to tune Oracle database 10.1.0.3.0 on slow performance
Date: Wed, 9 Jan 2008 00:49:34 -0800 (PST)
On Jan 9, 9:33 am, pejantan4u <pejanta..._at_gmail.com> wrote:
> 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
What percentage? Did you look at the execution plans? Why do you say it looks ok and then you say it isn't? Are there complaints from users?
> 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
Do you _think_ that it was enough or do you _know_ it?
> 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
I'd probably get myself a decent book on Oracle Tuning (there are quite a few out there but you can find recommendations in this group) and go from there.
robert Received on Wed Jan 09 2008 - 02:49:34 CST