That is a network function, not SQL*Net. SQL*Net operates through network objects called "sockets". If your socket survives, your database connection will survive , too. Your network engineer can usually slow the heartbeat (TCP_KEEPALIVE) to probing the other peer every 30 minutes. If the connection is reestablished within that interval, it will not die. Modern routers and hubs have many setup options and you can make them rather reliable. My advice is to talk to the CISCO guys.
> -----Original Message----- > From: Bond Mike A Contr OC-ALC/LPRC [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 28, 2003 4:14 PM > To: Multiple recipients of list ORACLE-L > Subject: SQL Net connection. > > > > Is there any possible way to retain/reinstate/continue a > SQLNet connection > if there is say a 10-second network outage? > > For example: If a session is established and then the network cable is > unplugged for 5 seconds and then replaced. Is there anyway to > keep that > connection alive? > > > > Michael Bond > OC-ALC\LPRC > Oracle DBA > 405 736-3840 > DSN 336-3840 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Bond Mike A Contr OC-ALC/LPRC > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
