Slow performance
- From: "Seema Singh" <oracledbam@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 23 Nov 2004 16:40:41 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
