Oracle Query for Sessions

This is a usefull query for active sessions to kill ;

SELECT  sess.osuser , 
		sess.machine ,  
		sess.process, 
		sess.status, 
		sess.username, 
		sess.schemaname,  
		sql.sql_text,
		'alter system kill session ''' || sess.SID || ',' || sess.serial# || ''';'  AS KILL_SCRIPT
  FROM v$session sess,
       v$sql     sql
 WHERE sql.sql_id(+) = sess.sql_id
   AND sess.TYPE	= 'USER'
   AND status 		= 'ACTIVE'
   AND sess.SID IN 
   (
   select sid from v$sql_monitor 
   where 1=1 
   AND status ='EXECUTING'  
--   AND elapsed_time/1000000> 300 
--   and username in ('GINAL')
   )

You can find more queries like this at the link below ;