We were using Vignette 4.x at my last client. We were
having persistent connections to the database and they
were stable. In fact, they were cut off because of the
web servers rebooting ;-)
- Suzy Vordos <lvordos_at_datsit.com> a écrit : >
> Yes, and the problem was eliminated by implementing
> DCD within
> sqlnet.ora:
>
> SQLNET.EXPIRE_TIME=30
>
> NOTE: If $TNS_ADMIN is other than
> $ORACLE_HOME/network/admin (as in our
> case), a softlink will be needed under
> $ORACLE_HOME/network/admin for
> $TNS_ADMIN/sqlnet.ora.
>
> Suzy
>
> Thomas Jeff wrote:
> >
> > Anyone else using Vignette experiencing problems
> with defunct processes?
> >
> > The defuncts multiply until there are a few
> thousand of them, and the box
> > runs out
> > processes in the process table, causing Vignette
> to die. This is the
> > Vignette
> > CMS, and it appears that the ctlds (delivery
> system) is requesting new
> > connections
> > to the database, depending on the load, but
> doesn't maintain them all the
> > time.
> > If one times out or is failing, it spawns another
> to handle the request,
> > queuing up
> > a whole bunch of processes trying to connect to
> the database.
> >
> > Thanks,
> > Jeff T
> > thomasje_at_tce.com
> >
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: Thomas Jeff
> > INET: ThomasJe_at_tce.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: 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).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
Received on Thu Oct 19 2000 - 02:59:49 CDT
