I'm having a problem with an app written in ASP.NET. I am explicitly opening and closing all of my connections to an Oracle DB, but when I select from V$Session, the sessions are shown as INACTIVE. If the app is being used by many users, I get an error stating that the maximum number of sessions has been exceeded (the Oracle Error is ORA-00020). Even if I kill the sessions using alter system, the killed sessions still count against me. Is there a way to completely kill the session, so I can keep the number of sessions I have down?
I appreciate any help.