Home » RDBMS Server » Performance Tuning » How to tune latch: cache buffers chains (Oracle Database 10g Enterprise Edition Release
How to tune latch: cache buffers chains [message #407638] Wed, 10 June 2009 23:06 Go to next message
Messages: 8
Registered: March 2009
Location: sion
Karma: 0
Junior Member

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

Re: How to tune latch: cache buffers chains [message #407641 is a reply to message #407638] Wed, 10 June 2009 23:16 Go to previous messageGo to next message
Messages: 25578
Registered: January 2009
Location: SoCal
Karma: 0
Senior Member
You need to help us by following the Posting Guidelines as stated below.
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

You need to repost using <code tags> as described in URL above so columns align to make data readable.
Re: How to tune latch: cache buffers chains [message #408007 is a reply to message #407638] Fri, 12 June 2009 23:15 Go to previous message
Messages: 696
Registered: January 2007
Location: Ha Noi, Viet Nam
Karma: 0
Senior Member
First time, you might to know about Latch Buffers Chains.
Latch Buffers Chains

Example to find Latches Currently Waited For

Some Note in Metalink you can find with keyword "latch buffers chains".


Previous Topic: Performance Tuning in Count(DISTINCT
Next Topic: Dynamic_sampling and partitioning
Goto Forum:

Current Time: Tue Aug 22 10:06:05 CDT 2017

Total time taken to generate the page: 0.09150 seconds