Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Profile to kill INACTIVE session

565226Apr 22 2010 — edited Apr 22 2010
Hi,

We have a web application which creates the session on Oracle and even after logging out from application, still the connection on oracle persist and status is 'INACTIVE'.

To fix the issue i created the profile and set the resource limit IDLE_TIME 30 and assign this profile to user. Now i observed that even after 30 min still the sessions exist and the status is also same i.e. INACTIVE'

Is this not the right way to kill the inactive sessions after sometime.

Please provide your inputs.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 20 2010
Added on Apr 22 2010
7 comments
2,655 views