Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SettingTime out for killed users
Hi
As far as I know it is a problem with Oracle.
The process is cleared quickly only if it does any call to the database, at
which
point it gets "your session have been killed" and it goes. If the process does
not do
any calls, which happens if the user process dies, then PMON is supposed to
clear
after it and remove the session from the session list.
However, in my experience, it does not happen in any predictable time. After
some
research, I found a note on Metalink saying that PMON can take anywhere from
several minutes to 24 hours to clear the session out. The documentation also
says
that "subsequent executions of ALTER SYSTEM KILL SESSION MAY kill the
session", but it does not work always, if at all.
The only way to clear the session out is to destroy the shadow process.
I would be interested to hear from somebody who knows a better solution to this problem.
Karen.
Ema wrote:
> Hi
>
> When I kill a database user with Oracle 8.0.5 Instance Manager,
> the user status become 'KILLED' but I still show it in the users list.
>
> I have set MAX_SESSIONS_PER_USER = 1 and, sometimes, when an application
> error occurs, the current user is still active and I can't connect me again.
>
> Is there an Oracle parameter to reduce time out for deleting killed users ?
>
> Thanks to all..
>
> Emanuele
Received on Fri Jul 21 2000 - 00:00:00 CDT