Re: buffer busy due to global cache/more...

Jack,

I happen to know that in 8.1.7 there were some bugs with lost messages that can cause problems, like sessions waiting on down grades or upgrades to complete. So the wait should be short (less than a second).

Anjo.

Jack van Zanen wrote:
>
> Hi
>
> This client has Oracle 8.1.7 OPS with 2 nodes.
> Every now and then sessions hang with this event being the only one that
> accumulates more time. How long can this downgrade/upgrade take?
>
> There is a bug in 8.1.7 related to this? Has anybody experienced it (Bug
> 1916409) and how can be proven w/o a doubt that this is customers problem?
>
> I will open a TAR on this as well to get input from WWS as well.
>
> -----Original Message-----
> Sent: woensdag 19 maart 2003 21:02
> To: Multiple recipients of list ORACLE-L
>
> Because the instance locks are now called Global Cache Services .. ;-)
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, March 19, 2003 7:59 PM
>
> > This can also happen during creating a consisten version of the
> > block with cache fusion enabled.
> >
> > -----Original Message-----
> > Sent: Wednesday, March 19, 2003 11:09 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> >
> > An instance lock that protects a buffer is being downgraded or upgrade,
> > while that is in process the buffer can't be accessed so sessions have to
> > wait on this event.
> >
> > Anjo.
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, March 19, 2003 3:38 PM
> >
> >
> > > Jack
> > > I did a quick search on Google and this seems to be related to using
> > RAC.
> > > Do you have that implemented?
> > >
> > > Dennis Williams
> > > DBA, 40%OCP, 100% DBA
> > > Lifetouch, Inc.
> > > dwilliams_at_lifetouch.com
> > >
> > >
> > > -----Original Message-----
> > > Sent: Wednesday, March 19, 2003 8:14 AM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Hi All,
> > >
> > >
> > > Anybody knows what this wait event is casued by??
> > >
> > > TIA
> > >
> > >
> > >
> > > Jacob A. van Zanen
> > > Oracle DBA
> > > Quant Systems Europe b.v.
> > > Tel : +31 (0) 251 - 268 268
> > > Mobile: +31 (0) 6 51308813
> > > Fax: +31 (0) 251 - 268 269
> > > E-mail: mailto:jack_at_quantsystems.nl
> > > Visit our web site at http://www.quantsystems.nl/
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Jack van Zanen
> > > INET: JACK_at_QUANTSYSTEMS.NL
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting services
> > > ---------------------------------------------------------------------
> > > 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.net
> > > --
> > > Author: DENNIS WILLIAMS
> > > INET: DWILLIAMS_at_LIFETOUCH.COM
> > >
> > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > > San Diego, California -- Mailing list and web hosting services
> > > ---------------------------------------------------------------------
> > > 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.net
> > --
> > Author: Anjo Kolk
> > INET: anjo_at_oraperf.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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.net
> > --
> > Author: Gogala, Mladen
> > INET: MGogala_at_oxhp.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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.net
> --
> Author: Anjo Kolk
> INET: anjo_at_oraperf.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
> --
> Author: Jack van Zanen
> INET: JACK_at_QUANTSYSTEMS.NL
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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
Received on Fri Mar 21 2003 - 09:16:35 CST