| How to tune latch: cache buffers chains [message #407638] |
Wed, 10 June 2009 23:06  |
|
|
Dear sir,
As my user getting performance problem i had ran awrreport for that time i am geeting too much wait event on cache buffers chains
Event Waits Timeouts Total Wait Time (s) Avg wait (ms) Waits /txn
latch: cache buffers chains 887,512 887,330 1,786 2 36.03
Top five events
Event Waits Time(s) Percent Total DB Time Wait Class
CPU time 13,052 48.23
latch: cache buffers chains 887,512 1,786 6.60 Concurrency
db file sequential read 252,445 1,593 5.89 User I/O
db file scattered read 47,792 175 .65 User I/O
db file parallel write 3,908 107 .40 System I/O
hit ratios is also good
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.98 In-memory Sort %: 100.00
Library Hit %: 99.82 Soft Parse %: 95.63
Execute to Parse %: 97.81 Latch Hit %: 91.36
Parse CPU to Parse Elapsd %: 30.35 % Non-Parse CPU: 98.99
Pls help what could be coz...
if any more information needed pls suggest...
[Updated on: Wed, 10 June 2009 23:11] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
