How to tune Oracle database 10.1.0.3.0 on slow performance

From: pejantan4u <pejantan4u_at_gmail.com>
Date: Wed, 9 Jan 2008 00:33:26 -0800 (PST)
Message-ID: <e6c53c37-6ca6-492d-a431-c1afe1889992@v67g2000hse.googlegroups.com>


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

thanks. Received on Wed Jan 09 2008 - 02:33:26 CST

Original text of this message