Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get SQL*Net v2 Dead Connection Detection to work

Re: How to get SQL*Net v2 Dead Connection Detection to work

From: John P. Higgins <jh33378_at_deere.com>
Date: 1998/09/30
Message-ID: <3612DD59.21CA7EEB@deere.com>#1/1

SQL*Net Dead Connection does not detect idle clients.

It only detects broken connections. It does this by using its own version of 'ping' to see if the client is still able to respond.

I think you want to set IDLE_TIME in the user's PROFILE.

Mike wrote:

> I have been trying to get sql*net dead connection detection to work.
>
> I have set the sqlnet.expire_time parameter, and the sqlnet.ora file
> exists on the server and clients.
>
> Clients can connect as usual, but can stay on as long as they like,
> even after long periods of inactivity.
>
> Any thoughts ?
Received on Wed Sep 30 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US