Query to find Active users and killing their sessions

Query to find of "Active users" :


SELECT  SID, Serial#, UserName, Status, SchemaName, Logon_Time
FROM  V$Session
WHERE
Status=‘ACTIVE’ AND
UserName IS  NOT  NULL ;
SELECT * FROM V$SESSION;
--------------------------------------------------------------------------------


The basic syntax for killing a session is shown below :


SQL> ALTER SYSTEM KILL SESSION 'sid,serial#';


--------------------------------------------------------------------------------