Re: Performance Problem but no Performance Tuning Tool
- From: LS Cheng <exriscer@xxxxxxxxx>
- To: ocat31@xxxxxxxxxx
- Date: Wed, 25 Nov 2009 10:23:09 +0100
Hi
You can still use Staspack, it's free.
ASH, AWR requires license as you already know.
I had a not very good experience once with AIX hardware changes, CPU usage
increased 20% after some hardware upgrades. It turned out that in the new
IBM LPAR the virtual CPU were running in a lower clock speed than the old
hardware (wow!) because the IBM guy chose to make more virtual CPU to favor
parallel operations instead of keeping or increase clock speed.
May not be your case because this was really specific and tooks me 1 month
to figure out (because everyone said hardware was better). You should start
with Statspack reports and determine first what is your bottleneck, CPU, I/O
systems or Memory.
Thanks
--
LSC
On Wed, Nov 25, 2009 at 5:06 AM, Sam <ocat31@xxxxxxxxxx> wrote:
>
> 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
>
>
Other related posts:
