select s.process,s.status
,s.username,s.schemaname
,s.sid,s.serial#
,to_char(s.logon_time,’dd-mm-yyyy hh24:mi’) logon_time
,substr(sq.sql_text,1,25) sql_txt
from v$session s
left outer join v$sql sq
on s.sql_id = sq.sql_id
order by 5;
And kill some session:
ALTER SYSTEM KILL SESSION ‘sid,serial#’;