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 disconnect a client session after a certain idle time?

Re: how to disconnect a client session after a certain idle time?

From: Jan-Marten Spit <j.m.spit_at_uptime.nl>
Date: Thu, 25 Mar 1999 13:01:27 +0100
Message-ID: <7dd7k7$2r5$1@zonnetje.NL.net>


Yes,

use profiles.

For example,

create profile test limit idle_time 10; (10 minutes)

alter user system profile test;

and finally:

add the line RESOURCE_LIMIT=TRUE to your init.ora. Restart database for this option to take effect.

JM

ewong74_at_netscape.net wrote in message <7dbjku$qe1$1_at_nnrp1.dejanews.com>...
>Hi there,
>
>I have a client using a client application(in other city) that connect to
my
>company's oracle server(both using net8). I would like to know will the
>connection get killed by oracle after certain idle time? Also, is there
any
>way to disconnect the client session after a certain idle time, say, 10
>hours?
>
>Thanks in advance.
>
>Ed
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Mar 25 1999 - 06:01:27 CST

Original text of this message

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