OraFAQ Forum: Performance Tuning » buffer cache handles

Home » RDBMS Server » Performance Tuning » buffer cache handles (oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

buffer cache handles [message #338640]

Tue, 05 August 2008 09:16

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

Report message to a moderator

Re: buffer cache handles [message #338657 is a reply to message #338640]

Tue, 05 August 2008 10:19

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Where did you see this is an event?

Regards
Michel

Report message to a moderator

Re: buffer cache handles [message #338660 is a reply to message #338657]

Tue, 05 August 2008 10:26

holdersav2000
Messages: 4
Registered: August 2008

Junior Member

Hi,

AWR report as one of the top 5 events

latch: cache buffer handles

regards

Report message to a moderator

Re: buffer cache handles [message #338663 is a reply to message #338640]

Tue, 05 August 2008 10:32

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

Report message to a moderator

Re: buffer cache handles [message #338675 is a reply to message #338663]

Tue, 05 August 2008 11:06

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

Report message to a moderator

Re: buffer cache handles [message #338687 is a reply to message #338640]

Tue, 05 August 2008 11:40

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

Report message to a moderator

Re: buffer cache handles [message #338857 is a reply to message #338687]

Wed, 06 August 2008 02:17

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 ?

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 07:23:45 CDT 2024