|
[oracle-l]
||
[Date Prev]
[03-2007 Date Index]
[Date Next]
||
[Thread Prev]
[03-2007 Thread Index]
[Thread Next]
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/
|
|
