>Hi All,
>
>We have an ERP system that we had purchased a while back. There is a predefined number of licenses that were purchased for this program. Unfortunately some times when a user turns off the program their session is not removed. If I view the V$SESSION I can see LICENSE users that I know are not valid. I use “alter system KILL session '50,251' IMMEDIATE;” to kill the session. But this does not free up the licensed session. It only lists it as killed. The ERP login screen does not filter out killed or inactive sessions when it queries the view for the COUNT(*) of LICENSE sessions.
>
>Is there a way I can DELETE the session? “Alter System Delete Session” does not work. I want to completely remove all the killed sessions. Currently we have to turn the instance of the database off to flush the sessions. Users are not 100% happy with that.
>
>TIA
>Mike.
>
>P.S. I use TOAD Version 7.4.0.3 Debugger for all my Oracle actions.
Hi, Michael
Try this:
alter system disconnect session 'sid,serial#' immediate;
Regards,
William Chadbourne
Senior Programmer/Analyst
State of Maine - DAFS App Team
Oracle - When you care enough to use the very best!!