RE: Urgent need information on Buffer busy wait P3 value

Anjo, if you don't mind me asking, where can these values be found in TFM, books, or on the web?

Thanks,

Scott Shafer
San Antonio, TX
210-581-6217

"Common sense will not accomplish great things. Simply become insane and desperate."

> -----Original Message-----
> From: Anjo Kolk [SMTP:anjo_at_oraperf.com]
> Sent: Thursday, March 14, 2002 12:25 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Urgent need information on Buffer busy wait P3 value
>
> 231, need a CR version of the block but found the current version of the
> block
> and that is being modified at this moment
> 220, looking for current version of block but that is bein modified
> 210, basically the same as 220.
>
> Anjo.
>
> 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: 
  INET: Scott.Shafer_at_dcpds.cpms.osd.mil

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).