Re: Urgent need information on Buffer busy wait P3 value

That information looks very familar ;-)

Anjo.

Christian Trassens wrote:

> Regarding the subject, p3 gives us the cause of the
> buffer busy waits. It is a code or id and it has
> changed since 7.3. Fe.:
> 0 the common one, the block is being read.
> 1012 a modification is happening on a SCUR or XCUR
> buffer but has not yet completed.
> 1013 or 130 block is being read by another session and
> no other suitable block image was found.
> 1014 or 110 a CURRENT block is being read by another
> session.
> 1016 or 210 a block is needed in SCUR or XCUR. It
> could escalate into a buffer deadlock.
> 1003 or 100 / 1007 or 200 it is related with undo and
> newing the block.....
>
> Regards.
> --- Anjo Kolk <anjo_at_oraperf.com> wrote:
> >
> > I just happen to know them ;-) As far as I know they
> > are not documented.
> >
> > Anjo.
> >
> > Scott.Shafer_at_dcpds.cpms.osd.mil wrote:
> >
> > > 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).
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Anjo Kolk
> > INET: anjo_at_oraperf.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).
>
> =====
> Ing. Christian Trassens
> Senior DBA & Unix Administrator
> Phone: 0034-699240979
> 0034-649824704
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Sports - live college hoops coverage
> http://sports.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Christian Trassens
> INET: ctrassens_at_yahoo.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.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).