Oracle Database Discussions

Hi Gurus,

I have a small query, my db is on 9.2.0.8, platform is windows 2003, my processes parameter has been set to 800, now when i do a select on v$resource_limit, it shows my current utilization for processes parameter as 730, so what I do is that I kill sessions which have been inactive for over a couple of days. After killing it when i check the current utilization value in v$resource_limit, it still shows as 730 and when i query v$session it shows that my active sessions are 12, inactive are over 300 and the sessions with status as KILLED are 300+.

Can anyone please tell me as to how I can get rid of the killed process and reduce my current utilization of processes?

Any solution or direction to a solution would be highly appreciated.

Thanks,
Ajinkya