Find and Clear INACTIVE SESSIONS

select 'alter system kill session '||' '||""||s.sid||','||s.serial# ||"' immediate;' FROM v$session s

WHERE s.type!= 'BACKGROUND'

AND S.TYPE='USER'

AND S.USERNAME='<SCHEMA NAME>'

AND TRUNC(S.LOGON_TIME) < '28-JUN-2018'

AND S.STATUS='INACTIVE'

— and last_call_et > 30 — more than 30 mins inactive