RE: Performance Problem but no Performance Tuning Tool
- From: Herald ten Dam <Herald.ten.Dam@xxxxxxxxxxxxxxx>
- To: "ocat31@xxxxxxxxxx" <ocat31@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 Nov 2009 08:22:05 +0100
Hi,
for AIX systems you should look at this paper:
http://www-03.ibm.com/support/techdocs/atsmastr.nsf/5cb5ed706d254a8186256c71006d2e0a/bae31a51a00fa0018625721f00268dc4/$FILE/Oracle%20Architecture%20and%20Tuning%20on%20AIX%20(v%201.31).pdf
It gives the best idea how to setup an AIX system with Oracle. Mostly the
performance comes from not setting the memory ideally for Oracle (maxperm and
minperm).
For monitoring AIX you can use the internal TOPAS, but better you look for
NMON: http://www.ibm.com/developerworks/aix/library/au-analyze_aix/ (This is
included in AIX 6.1).
You could still use the DBconsole. Look at the performance tab you can have an
idea what is wrong in your database. You can also still use the old STATSPACK.
It is still included.
Herald ten Dam
Superconsult
________________________________
Van: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] namens Sam
[ocat31@xxxxxxxxxx]
Verzonden: woensdag 25 november 2009 5:06
Aan: oracle-l@xxxxxxxxxxxxx
Onderwerp: Performance Problem but no Performance Tuning Tool
Hi all,
I work for an organization that has no performance tuning tools, and one of my
jobs is to tune our enterprise Oracle 10.2.0.4 database on AIX 5.3. A few
changes were made to our environment on a long weekend in October, and since
that time response time has been a lot worse. We had a consultant come in for
a couple of weeks, but performance problems remain. Here are the changes made
on that weekend:
1) Move the databases to more powerful hardware. We remained at AIX 5.3.
2) Upgrade from 10.2.0.3 to 10.2.0.4
3) All unnecessary network ports were closed (it took a while to get all the
needed ports open)
4) Prior to the upgrade, our primary enterprise database had its own set of
dedicated SAN disks. I don't know how many spindles. Other databases were on
different SAN disks. After the upgrade, the SAN consisted of 16 spindles, and
all our Oracle databases are spread across all 16 spindles; i.e., there are no
longer dedicated disks just for the enterprise database. I haven't been told
the RAID type has changed, so for now I assume it is the same.
If anybody has scripts that can help isolate the root cause of the general
performance degradation that would be most helpful. I am familiar with Oracle
wait event analysis, but without access to a Performance Tuning tool I do not
have a good method of pin-pointing what the problem waits are or what is
causing the waits to exist.
I know dbConsole comes with a very good tuning pack, but our free trial period
is over. Also, I think that using the ASH scripts requires an additional
license, so that is also not an option for me.
So if somebody has scripts to share, that would be helpful to me.
Thanks very much,
SB
!��� 0~���+-����?���?���rW�
Other related posts: