A setting of zero tells the server to never poll the connections and verify
that they are active. This allows firewalls and various other middlemen to
terminate inactive connections based on the fact that there is no sql*net
traffic coming through the network. By setting it to anything other that
zero, it forces the connections to be polled from the server and therefore
by default creates network traffic.
--Michael
-----Original Message-----
Sent: Monday, July 16, 2001 12:21 PM
To: Multiple recipients of list ORACLE-L
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jenkins, Michael
INET: Michael.Jenkins_at_Nextel.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:52:37 CDT