Illinois School of Technology IST: check long sessions

SQL> select blocking_instance,sid Waiter_sid,serial# waiter_serial#,osuser,machine,username,BLOCKING_SESSION,status,wait_class,seconds_in_wait from gv$session where blocking_session is not NULL and seconds_in_wait>600 order by blocking_session;

no rows selected

SQL> select 'alter system kill session '''||sid||','||serial#||',@'||inst_id||''' immediate;' from gv$session where sql_id='bb0svux7qk1sd';