Re: time out

Paul Drake wrote:

> 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

One kills sessions for many reasons. To me the most important is security. And I can't honestly answer your question other than to say better dead than idle.

Daniel Morgan Received on Fri Feb 14 2003 - 03:19:37 CST