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).
Received on Fri Mar 15 2002 - 02:38:18 CST
