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!

Releasing resources while Killing a session

277530Oct 23 2004 — edited Oct 24 2004

Hi All

When I kill a session using:

ALTER SYSTEM KILL SESSION '12,2098'

command..The resources are not released by Oracle unitl the user whose session is killed tries to perform any further activity.

This I have checked in V$process table where a dedicated user process row is still there whereas the session is killed. it is only when Killed user session tries to perform any activity this row is removed.

How to Release all the resources when a session is killed and how to reduce the no of process when a session is killed.??

Thanks
Rohit Goswami

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 21 2004

Added on Oct 23 2004

#general-database-discussions

5 comments

1,041 views