查:
select s.machine,
s.osuser "O/S-User",
s.username "Ora-User",
s.sid "Session-ID",
s.serial# "Serial",
s.process "Process-ID",
s.status "Status",
l.name "Obj Locked",
l.mode_held "Lock Mode"
from v$session s, dba_dml_locks l
where l.session_id = s.sid
解:
alter system kill session '14,397';
第一个是sid,第二个是serial#