Urgent need information on Buffer busy wait P3 value

From: Arun Chakrapani <ArunC_at_1800FLOWERS.com>
Date: Thu, 14 Mar 2002 09:33:30 -0800
Message-ID: <F001.00429866.20020314093330@fatcity.com>

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: Arun Chakrapani
  INET: ArunC_at_1800FLOWERS.com

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). Received on Thu Mar 14 2002 - 11:33:30 CST