KILL AND DROP CONNECTION ORLANSOFT

SCRIPT

select lastreqtime,now(),conn_name,'Drop Connection '|| conn_id || '; commit;', list(table_name) from sa_locks() a join sa_conn_info() b on a.conn_id = b.number 
    group by lastreqtime,conn_name,conn_id
    order by lastreqtime asc