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