Re: oracle timeouts

Also look at SQLNET.EXPIRE_TIME in the SQLNET.ORA file.

HTH,
Brian

Rauf Sarwar wrote:
>
> 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

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"