Home » RDBMS Server » Performance Tuning » buffer cache handles (oracle 10g)
buffer cache handles [message #338640] Tue, 05 August 2008 09:16 Go to next message
holdersav2000
Messages: 4
Registered: August 2008
Junior Member
Hi,

I am having difficulty finding information the event 'buffer cache handle'. We are seeing this event and cannot find out enough information to resolve

thanks

Re: buffer cache handles [message #338657 is a reply to message #338640] Tue, 05 August 2008 10:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Where did you see this is an event?

Regards
Michel
Re: buffer cache handles [message #338660 is a reply to message #338657] Tue, 05 August 2008 10:26 Go to previous messageGo to next message
holdersav2000
Messages: 4
Registered: August 2008
Junior Member
Hi,

AWR report as one of the top 5 events

latch: cache buffer handles

regards
Re: buffer cache handles [message #338663 is a reply to message #338640] Tue, 05 August 2008 10:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
GOOGLE is your friend but only if you use it!
Results 1 - 10 of about 33,400 for oracle latch: cache buffer handles
Re: buffer cache handles [message #338675 is a reply to message #338663] Tue, 05 August 2008 11:06 Go to previous messageGo to next message
holdersav2000
Messages: 4
Registered: August 2008
Junior Member
Thanks for your input. Google is indeed a great tool but as I am sure you have found out over the years, quality can very often be poor. Please note that this does not only apply to Google as a search engine.

You see I have gone through a lot of google 'hits' and metalink but there is little information except from Steve Adams that says that the buffer handles act as the lock structures to buffer locks.... (please find this in page 54 and not google).

So I was looking for something a bit more....what does it protect beside buffer locks, which buffer locks or latches; how does it relate to _db_handles or does it etc etc

regards



Re: buffer cache handles [message #338687 is a reply to message #338640] Tue, 05 August 2008 11:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
from Metalink
  	Subject 	Doc ID 	Modified Date 	Product 	Platform 	Type
1. 	Systemwide Tuning using STATSPACK Reports
Execute to Parse %: -1.75 Latch Hit %: 99.11 Parse CPU to Parse Elapsd %: 52.66 % Non-Parse CPU: 99.99 Shared Pool Statistics Begin End ------ ------ Memory Usage %: 42.07 43.53 % SQL with executions>

	228913.1  	14-JUL-2008 	Oracle Server - Enterprise Edition 	Generic 	BULLETIN
2. 	How to Identify Which Latch is Associated with a "latch free" wait
Version: 8.1.7.4 to 10.2.0.4 Information in this document applies to any platform. Goal It is important to identify which latch is associated with latch free waits when tuning a database for latch waits. For versions prior to 10g

	413942.1  	04-JUN-2007 	Oracle Server - Enterprise Edition 	Generic
Re: buffer cache handles [message #338857 is a reply to message #338687] Wed, 06 August 2008 02:17 Go to previous message
holdersav2000
Messages: 4
Registered: August 2008
Junior Member
thanks. I checked the metalink notes in case I had missed them but but lreading them they do not explain what a buffer handle wait event actually is. I know the latch I am waiting for, 'cache buffer handles',but i am trying to find out what it is trying to protect ?

Previous Topic: selectivity in index usage
Next Topic: to decide pctused,pctfree in Oracle8i (merged)
Goto Forum:
  


Current Time: Sun Nov 03 06:34:57 CST 2024