Re: "gc buffer busy" wait Cause ?

  • From: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
  • To: VIVEK_SHARMA@xxxxxxxxxxx
  • Date: Wed, 14 Mar 2007 12:40:32 -0700

Treat GC buffer busy as normal buffer busy wait event. If you have my
OWI/RAC book there are some scripts the book and you can find the system
calls causing the buffer busy wait .

Or  look at the segment statistics and see the segments/object responsible
for those waits. It would be pretty simple once you get the culprit objects.


--
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/

Other related posts: