oracle 查锁与解锁

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