Re: buffer busy waits PUZZLES

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Tue, 10 May 2005 15:10:36 +0200
Message-ID: <3b0f44a105051006104c1c6dfb@mail.gmail.com>

Jaffar:

What is the most common reason code (p3=3D?) you are noticing? Tracing the sessions with 10046^8 will give you more information about the type of the block and the reason code for buffer busy wait..

(btw the waits are 'buffer busy waits' WAIT or 'buffer busy' WAIT?) If it is 'buffer busy' WAITs then the issue may not be with freelists.

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 10 2005 - 09:15:06 CDT