ora-14550问题解决

select a.sid, a.serial#,

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

-----------------------------