Re: buffer busy waits

  • From: "Anjo Kolk" <anjo.kolk@xxxxxxxxxxx>
  • To: sjaffarhussain@xxxxxxxxx
  • Date: Mon, 21 Aug 2006 10:22:43 +0200

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@xxxxxxxxx> 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."
--
//www.freelists.org/webpage/oracle-l





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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2006