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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
