set pages 2000
SELECT 'ALTER SYSTEM KILL SESSION '''||sid||','||serial#||''' IMMEDIATE;'
  FROM v$session s
 WHERE s.saddr not in (SELECT ses_addr FROM V$transaction)
   and LAST_CALL_ET > 7200
   and program <> 'oracle'
   and osuser <> 'oracle';