查：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#
