OraFAQ Forum: Performance Tuning » resolving buffer busy waits

Home » RDBMS Server » Performance Tuning » resolving buffer busy waits

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

resolving buffer busy waits [message #164778]

Sun, 26 March 2006 00:34

tridentadm
Messages: 142
Registered: March 2006

Senior Member

if i am observing 'buffer busy waits' in wait events how should i go about resolving ??

should i be
1) chainging storage parameters for that object (ie. freelist, extents etc.)
2) 'or' should i be putting the object in 'keep','recycle' pool
3) how to identify if candidate object to be in 'keep' or 'recycle' pool

Report message to a moderator

Re: resolving buffer busy waits [message #164804 is a reply to message #164778]

Sun, 26 March 2006 14:54

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

Here's what I got from Googling "buffer busy waits".

Report message to a moderator

Re: resolving buffer busy waits [message #165595 is a reply to message #164778]

Fri, 31 March 2006 00:43

madhusunkara
Messages: 59
Registered: March 2006
Location: hyderabad,india

Member

before doing anything give a try doing sql tuning,it is mostly application problem. putting tables/indexs in lower size buffers is only a work around

Thanks

Report message to a moderator

Previous Topic:	How I can Eliminate the Full Table scan for the following query?
Next Topic:	Can anyone do the guidance to learn Performance Tuning?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 08:40:12 CST 2024