Re: Slow performance

My advice would be to talk to the users to find which processes are unbearably slow, or if there are many, which are the most important to resolve as well.

Then work from there. Trace an isolated session, find out where it is spending it's time, fix the problem, or learn to live with it if too expensive to fix and move on to the next one.

No silver bullets...

Jared

On Tue, 23 Nov 2004 16:40:41 -0500, Seema Singh <oracledbam_at_hotmail.com> wrote:
> Hi,
> I have been noticing slow perormance on one of DB box.Applications are
> looking slow.
> Statspack report show
> Top 5 Wait Events
> ~~~~~~~~~~~~~~~~~ Wait %
> Total
> Event Waits Time (cs) Wt
> Time
> -------------------------------------------- ------------ ------------
> -------
> direct path write 49,152 63,188
> 37.02
> db file sequential read 84,584 43,686
> 25.60
> db file parallel write 2,192 18,168
> 10.65
> log file sync 10,422 12,433
> 7.28
> log file parallel write 10,467 12,225
> 7.16
>
> Instance Efficiency Percentages (Target 100%)
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Buffer Nowait %: 100.00 Redo NoWait %: 100.00
> Buffer Hit %: 73.98 In-memory Sort %: 99.98
> Library Hit %: 90.88 Soft Parse %: 74.03
> Execute to Parse %: 5.58 Latch Hit %: 99.99
> Parse CPU to Parse Elapsd %: 97.78 % Non-Parse CPU: 100.00
>
> Other stats are looking fine.I noticed couple of times system is spending
> more time on IO.
> I also noticed more IO read/writes on temp tablespace.
> pelase advice
>
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l