Re: buffer busy waits

From: Anjo Kolk <anjo.kolk_at_oraperf.com>
Date: Mon, 21 Aug 2006 10:22:43 +0200
Message-ID: <54973d5e0608210122kb108fd2na5c2991be5423420@mail.gmail.com>

One thing to realize is the original 'buffer busy waits' has now been split into 'read by another session' (or something like that) and 'buffer busy waits'. So in 10g it really focusses buffer contention inside the buffer cache.

Anjo.

On 8/21/06, Syed Jaffar Hussain <sjaffarhussain_at_gmail.com> wrote:
>
> Hi List,
>
> Does any one has the complete list of reason code (p1) of buffer busy
> waits for Oracle 10g Rel.2?
> I have noticed many new p3 values in 10g Rel.2, comparitively 9i Rel.2.
> I tried findout, but, couldn't get it.
> If any one has the complete list and its discription, please, send it
> to me or give me the link.
>
>
> --
> Best Regards,
> Syed Jaffar Hussain
> 8i,9i & 10g OCP DBA
> Banque Saudi Fransi,
> Saudi Arabia
>
> I blog at :http://jaffardba.blogspot.com/
> http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
>
> ----------------------------------------------------------------------------------
> "Winners don't do different things. They do things differently."
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Anjo Kolk
Owner and Founder OraPerf Projects
tel:    +31-577-712000
mob: +31-6-55340888

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

Received on Mon Aug 21 2006 - 03:22:43 CDT