I was under the impression that setting it to zero meant that the
connnections would wait indefinately. Like when I was receiving "end of
file on communication" errors setting it to 0 was suggested.
KK
-----Original Message-----
Trassens
Sent: Monday, July 16, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L
I meant that if you want to use expire_time feature,
you'll need to set it with a value greater than 0.
Remember that the value is in minutes. F.e.:
SQLNET.EXPIRE_TIME=20 .....means that every twenty
minute SQL*Net or Net8 polls each connection
SQLNET.EXPIRE_TIME=0.....means that SQL*NET or NET8
doesn't poll any connection.
Is it clear ?.
Regards.
- Kevin Kostyszyn <kevin_at_dulcian.com> wrote:
> What? What do you mean?
> KK
>
> -----Original Message-----
> Trassens
> Sent: Monday, July 16, 2001 10:18 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Beware that SQLNET.EXPIRE_TIME=0 doesn't activate
> this
> feature. Is the same that set it with huge value.
>
> Regards.
>
>
> --- Kevin Kostyszyn <kevin_at_dulcian.com> wrote:
> > I believe that you could try and change the
> settings
> > in the sqlnet.ora file
> > on the server side, SQLNET EXPIRE_TIME = 0. This
> > may help:)
> > KK
> >
> > -----Original Message-----
> > Admin.ISISAFBX01.IS_at_mail.mfinante.gv.ro
> > Sent: Monday, July 16, 2001 2:50 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > We have a network that have some computers with
> a
> > lazy connection. Here,
> > on these computers, we have some ORACLE users.
> > On these computers running an application (I
> don't
> > have acces to the code
> > of this application.) When I work, sometimes, I
> have
> > an ORACLE error :
> > <<ORA-03114: not connected to Oracle >>.
> > A ping to these computers don't show me that
> > something is wrong.
> > Everything is OK. This connection accept an
> transfer
> > at 100 kBytes that is
> > enough for me. The time of response for my ping is
> > good, too (time < 10
> > ms).
> > I think is time of response, yet. I don't have
> > other ideea. So, THE
> > QUESTIN:
> > << Is there in ORACLE a setting that accept
> > connection with lazy line?
> > Something like a timeout settings?>>
> >
> > Thank you very much !
> >
> > Marian
> >
> >
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author:
> > INET: Admin.ISISAFBX01.IS_at_mail.mfinante.gv.ro
> >
> > 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: Kevin Kostyszyn
> > INET: kevin_at_dulcian.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).
>
>
> =====
> Eng. Christian Trassens
> Senior DBA
> Systems Engineer
> ctrassens_at_yahoo.com
> ctrassens_at_hotmail.com
> Phone : 541149816062
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.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: Kevin Kostyszyn
> INET: kevin_at_dulcian.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).
Eng. Christian Trassens
Senior DBA
Systems Engineer
ctrassens_at_yahoo.com
ctrassens_at_hotmail.com
Phone : 541149816062
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.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: Kevin Kostyszyn
INET: kevin_at_dulcian.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 Mon Jul 16 2001 - 10:10:05 CDT
