Slow performance

From: Seema Singh <oracledbam_at_hotmail.com>
Date: Tue, 23 Nov 2004 16:40:41 -0500
Message-ID: <BAY19-F1018107B5773217D733A09D3C70@phx.gbl>

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 Received on Tue Nov 23 2004 - 18:24:52 CST