Re: time out

DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E4BCAD1.5E69A7D9_at_exesolutions.com>...
> Eric DN wrote:
>
> > Hello,
> >
> > 2 questions only:
> >
> > -Where is the parameter in Oracle 9i to setting timeout session ?
> >
> > - Where read détails error code oracle on the web ?
> >
> > Thank you for your help.
>
> Go to http://tahiti.oracle.com and look up "PROFILE".
>
> You can either modify the default profile or create your own and assign
> it to specific users.
>
> CREATE PROFILE developer LIMIT
> IDLE_TIME 30;
>
> You could also add other useful functions such as:
>
> CREATE PROFILE end_user LIMIT
> IDLE_TIME 30
> PASSWORD_LIFE_TIME 60
> PASSWORD_GRACE_TIME 10
> PASSWORD_REUSE_TIME 0
> PASSWORD_REUSE_MAX 0
> FAILED_LOGIN_ATTEMPTS 3
> PASSWORD_LOCK_TIME 2;
>
> and more. Check it out.
>
> Daniel Morgan

Daniel,

sorry for being lazy, but in 9i does the instance still wait for the sniped session to make another call before the session status goes from "SNIPED" to "KILLED"?
setting connection timeouts seemed to be rather less than useful (in the win32 world) as the session resources would not be released in a long time after the session was sniped by the profile limit.

thanks,

Paul Received on Fri Feb 14 2003 - 00:53:34 CST