Re: TNS TIMER!!

From: Babette Turner-Underwood <babettet_at_you.cant.spam.me>
Date: Fri, 13 Nov 1998 20:44:10 GMT
Message-ID: <uS032.880$5n1.6637511@news.magma.ca>

I tried this today and had some UNEXPECTED results!!!

I put

sqlnet.expire_time = 10
in my server side sqlnet.ora file
(but did NOT restart the listener).

I was REALLY surprised when a developer called an said he had gotten an error message (Error are recursive level... the one you get when in SQL*Plus you Ctrl-C a query).

He was running a Pro*C program that takes 15 - 20 minutes to run. After about 10 minutes he was disconnected. I thought the sqlnet connection would only be dropped for non-active connections. What is happening here??

--
Babette Turner-Underwood, TMI Communications babettet_at_tmi.ca.NOSPAM (remove appropriate part to e-mail me)

Kevin Loney wrote in message ...
>I think you're looking for SQLNET.EXPIRE_TIME , which is set in the
>sqlnet.ora file on the client side.
>
>There's also CONNECT_TIMEOUT_LISTENER in the listener.ora file.
>
>hth.
>Kevin.
>http://www.kevinloney.com
>
>naveen_arora_at_my-dejanews.com wrote in message
><729apv$8lh$1_at_nnrp1.dejanews.com>...
>>hi,
>>
>>I need to change TNS timeout value at level of sqlnet, , can any one tell
>>me paramter and where to modify.
>>
>
>
Received on Fri Nov 13 1998 - 14:44:10 CST