SQL command to kill a session/sid

                                                                                                                                                                      

Scenario:

SQL command to kill a session/sid

Solution:

ALTER SYSTEM KILL SESSION 'sid,serial#';

Query to find SID :

select module, a.sid,machine, b.SQL_TEXT,piece

from v$session a,v$sqltext b

where status='ACTIVE'

and a.SQL_ADDRESS=b.ADDRESS

--and a.USERNAME='NAME'

and sid=95

order by sid,piece;

Query to find serial#

select * from v$session where type = 'USER' and status = 'ACTIVE';--t0 get serial no