Re: IDLE_TIME and EXPIRE_TIME

What sort of activity? What if the session is idle?

On Fri, 18 Feb 2000 00:43:54 +0100, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>Expire_time, this will work only if it is in the sqlnet.ora on the server
>and checks for every <n> minutes. It will simply poll all sessions to see if
>there's any activity.
>Idle_time: as soon as the idle_time is exceeded the session should be marked
>as 'sniped'. It is not disconnected however. It IS disconnected when the
>operator returns to his session and tries to do something. At that moment
>the session is killed and he/she gets an appropiate message.
>
>Hth,
>
>Sybrand Bakker, Oracle DBA
>
>Doug Cowles <dcowles_at_i84.net> wrote in message
>news:38af81b2.6182619_at_news.remarq.com...
>> As I understand it, the SQLNET.EXPIRE_TIME = 10 / minutes will check
>> for dead client connections ---- (once every 10 minutes?) . By what
>> mechanism does sqlnet "know" that a connection is dead? Will it work
>> on JDBC connections that have lost their client connection as well?
>> How reliable is it? I've heard "rumors" that sometimes it will
>> incorrectly boot people off. And... The IDLE_TIME paramter in the
>> profile is pretty much suppossed to kick off sessions that have had no
>> activity in a specified amount of time. I havne't had much luck with
>> this. I set it to 180 minutes on the profile for the developer's
>> username so that overnight, when no developers are using the system, I
>> would think that all of their connections would be gone.. but they're
>> there at 6am, or at least some of them; they're harder to track
>> because JDBC sessions all run as osuser "oracle". Is there something
>> going on like a held lock that doesn't qualify them as idle? Or is
>> someone secretly dialing in at night. Also, I assume that EXPIRE_TIME
>> is not just a sql*net version of IDLE_TIME and there is some actual
>> intelligence behind it? Mabye not, I don't know.. I apologize for
>> stuffing a lot of questions into one post but I get a lot of calls
>> during development asking me to please kill sessions that are no
>> longer connected to the developer's "framework" (transaction layer)
>> and I am hoping for a solution that can free up some of my time.
>> However, I'm interested in more detail to the above questions anyhow.
>> Thanks,
>>
>> Doug C.
>
>
Received on Sat Feb 19 2000 - 18:35:30 CST