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!

Killed sessions still present in v$session

John-MKAug 29 2012 — edited Aug 30 2012
Hi,

There are 42 sessions which are KILLED but still present in the v$session view. v$Resource_limit is to keep 300 sessions. My question is: are these killed sessions count for example if v$session is showing 250 rows and out of that 50 are marked Killed. 200 sessions will be counted or 250??

Secondly, how I can KILL all the open or multiple sessions or find them at the Unix OS level which process id to kill at OS level too??
select sid,serial#,osuser from v$session where status='KILLED';

       SID    SERIAL# OSUSER											
---------- ---------- ---------------
	56	 8542 SYSTEM	
- - 
42 rows selected
Thanks a lot in advance.

Regards
This post has been answered by kuljeet singh - on Aug 30 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 27 2012
Added on Aug 29 2012
13 comments
10,983 views