Re: Urgent need information on Buffer busy wait P3 value

In general the title of what is in P1 P2 and P3 is in P1TEXT P2TEXT and P3TEXT. In this case, it just says 'id.'

The documentation is also unhelpful:

http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76961/apa3.htm#264253

Event Name              P1       P2      P3 
-----------------------	-------- ------- -------
buffer busy waits       file#    block#  id 

Good reply though and links to ixora.com.au on Metalink Forums from Mark Bobak of ProQuest:

> From: Mark Bobak 15-Jan-02 16:07
> Subject: Re : Buffer busy waits
>
> ... Buffer busy waits can be caused by several different
> scenarios. Also, they are extremely shortlived, and so are difficult
> to track down. Finally, when looking at buffer busy wait events, the
> P3 values are critical for understanding the cause and knowing what
> to tune. In 8.1.6+, the P3 values are three digit numbers. The first
> digit is 1 if it's a consistent read, 2 if it's a current read. The
> second digit is a 2 if requesting an exclusive lock, 3 if requesting
> a shared lock. The third digit is 0, unless a read is being done to
> satisfy a consistent read rollback, in which case it will be a 1.
>
> More detail on the above is available at:
> http://www.ixora.com.au/q+a/0104/27230622.htm
>
> Also, to help you track down and get a better handle on the types of
> buffer busy waits you are experiencing, go to:
> http://www.ixora.com.au/scripts/cache.htm
> and check out buffer_busy_waits.sql, buffer_busy_sample.sql, and
> trace_waits.sql.
>
> The buffer_busy_waits.sql script, in particular, will give you the
> class of the block being waited on, which will help you determine
> what types of blocks you're waiting on. That, combined with the P3
> values, will shed some light on what kinds of waits you're
> encountering...

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton

On Thu, 14 Mar 2002, Arun Chakrapani wrote:



> Can somebody please let me know what the following number means in the p3


> value of session wait when there is a bufferbusy wait,

> I am not able to get the docs on these values,The version is 8.1.7.3

> 

> SID        FNNAM                                       BLOCK      P3

> ---------- ------------------------------------------- ---------- ----------

>  895 /db4b/oradata/800B/800P_atlas_index3.dbf        	115301        220

> 1183 /db4b/oradata/800B/800P_atlas_index5.dbf		 70790        210

> 1137 /db8b/oradata/800B/800P_rbs6_2.dbf                4896        231


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).