select a.sid, a.serial#,
a.paddr， 'alter system kill session ''' || a.sid || ',' || a.serial# || ''';' AS kill_sessionFROM v$session a
WHERE a.sid in (select sid from v$enqueue_lock t where t.type='TO');
-----------------------------
Dylan Presents.