OraFAQ Forum: Performance Tuning » Tuning Buffer cache and Buffer Busy Waits.

Home » RDBMS Server » Performance Tuning » Tuning Buffer cache and Buffer Busy Waits. (oracle 9.2.0.1.0 windows)

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

Tuning Buffer cache and Buffer Busy Waits. [message #477685]

Sun, 03 October 2010 13:54

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi,

Is there any relationship b/w tuning BUFFER CACHE and BUFFER BUSY WAITS?

1) Buffer Busy Waits are happening as the Userprocess found the same Datablock is being used by another user in the BUFFER CACHE.
2) And also happens, when the server process found the same Datablock are being used in the Datafile.

Am I right?

Thanks in advance

Report message to a moderator

Re: Tuning Buffer cache and Buffer Busy Waits. [message #477686 is a reply to message #477685]

Sun, 03 October 2010 13:57

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Tuning Buffer cache and Buffer Busy Waits. [message #477687 is a reply to message #477686]

Sun, 03 October 2010 14:26

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi,

Anyone knows the answer for my above question, please answer me.......

Thanks

Report message to a moderator

Re: Tuning Buffer cache and Buffer Busy Waits. [message #477688 is a reply to message #477687]

Sun, 03 October 2010 14:33

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Do you think your behaviour deserves any answer?

Regards
Michel

Report message to a moderator

Re: Tuning Buffer cache and Buffer Busy Waits. [message #477690 is a reply to message #477686]

Sun, 03 October 2010 14:53

muktha_22
Messages: 527
Registered: December 2009

Senior Member

Hi,

Anyone knows the answer for my above question, please answer me.......

Thanks

Report message to a moderator

Re: Tuning Buffer cache and Buffer Busy Waits. [message #477691 is a reply to message #477690]

Sun, 03 October 2010 14:57

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Sun, 03 October 2010 21:33

Do you think your behaviour deserves any answer?

Regards
Michel

Report message to a moderator

Previous Topic:	Column width convergation with Index performance
Next Topic:	Query running way too slow

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 07:32:41 CST 2024