Re: (?) Dead Connection Detection (?)

From: Davide Bellesi <davide.bellesi_at_visto.com>
Date: Mon, 11 Sep 2000 06:15:13 -0700
Message-Id: <10616.116626@fatcity.com>

Hi to everybody,
I'm facing with a lot of timeouts on PX events :

EVENT                   WAITS   TIMEOUTS  %TIMEOUTS =20
----------------------- ------- -------- ---------
PX Deq: Execution Msg=09868=09   404=09      47
PX Deq: Execute Reply=091662=09   752=09      45
latch free=09       58054=09 41220=09      71

I wanted to see if the amounts of latch timeouts was related to the timeo= uts on the PX events .. and I saw :

LATCH                         GETS    MISSES   %MISSES
---------------------------- ------- -------- ----
parallel query stats=09        8135    3582=0944

parallel query alloc buffer 315060 154756=0949

I'd like to have someone's advice about solving this problem

Thanks in advance
Davide

_________________________________________________________________________=

__
> > Visit http://www.visto.com/info, your free web-based communications c=
enter.
> > Visto.com. Life on the Dot.
> >
> > --
> > Author: Davide Bellesi
> > INET: davide.bellesi_at_visto.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing List=
s
> > --------------------------------------------------------------------
> > 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).
> >
> >
> >
> > _____________________________________________________________________=

> > Visit http://www.visto.com/info, your free web-based communications c=
enter.
> > Visto.com. Life on the Dot.
> >
> > --
> > Author: Davide Bellesi
> > INET: davide.bellesi_at_visto.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing List=
s
> > --------------------------------------------------------------------
> > 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).

>=20
> --
> Author: Tom Pall
>   INET: tom_at_cdproc.com
>=20
> 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).

--=20
Author: Suzy Vordos
INET: lvordos_at_datsit.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).

_________________________________________________________________________=

__
Visit http://www.visto.com/info, your free web-based communications cente= Received on Mon Sep 11 2000 - 08:15:13 CDT