Re: need help on statspack report, Parse CPU to Parse Elapsd %

From: DJ <nospamplease_at_goaway.com>
Date: Sat, 6 Mar 2004 17:54:42 -0000
Message-ID: <nfo2c.1820$sq2.63@newsfe2-gui.server.ntli.net>

"Joe" <yung103_at_netvigator.com> wrote in message news:c2co7r$nk31959_at_imsp212.netvigator.com...
> Hi Oracle Experts,
>
> Attached please find the statspack report I generated on 04-MAR-2004.
> We are running Oracle eBuisness Suite on AIX.
> The users complain about the performance of the system, and I start to
> investigate what is causing this.
> In the investigation process, I find the Oracle process is taking
> unreasonable high CPU resources.
> My goal is how to improve this unreasonable high CPU usage.
> I already try my best to spread the I/O.
>
> Any input is appreciated.
> Thanks.
>
> Regards,
> Joe
>
>
>

where is the statspack report from when it was running normally? Received on Sat Mar 06 2004 - 11:54:42 CST