Re: How to tune Oracle database 10.1.0.3.0 on slow performance
Date: Wed, 9 Jan 2008 01:02:38 -0800 (PST)
thanks for ur response.
On Jan 9, 3:49 pm, Robert Klemme <shortcut..._at_googlemail.com> wrote:
> 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
i saw it on EM in Top SQL section. i said ok when i saw the
performance of database on EM performance section, but when i saw in
Top sql section, there are few queries that show large activity
percentage on EM. Users complaints about, why the database took a long
time, when they run the application.
> > 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?
I think, because i don't know for sure.
> > 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.
> Kind regards
Received on Wed Jan 09 2008 - 03:02:38 CST