Re: oracle timeouts

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 5 Jun 2003 10:37:21 -0700
Message-ID: <92eeeff0.0306050937.817b51d@posting.google.com>

Paul <raf95_at_hotmail.com> wrote in message news:<3EDF0904.6040201_at_hotmail.com>...
> is there any automatic timeout for a dormant session connection to oracle?
>
> if there is where is the setting held?
>
> thanks all

IDLE_TIME resource limit of a profile. To limit idle time to e.g. 60 minutes,

SQL> CREATE USER foo_user IDENTIFIED BY foo_user;
SQL> ALTER PROFILE foo_profile LIMIT IDLE_TIME 60;
SQL> ALTER USER foo_user PROFILE foo_profile;

Regards
/Rauf Sarwar Received on Thu Jun 05 2003 - 12:37:21 CDT