Oracle解锁

Oracle解锁
 查询：select object_name as 对象名称,
       s.sid,
       s.serial#,
       p.spid as 系统进程号,
       'ALTER SYSTEM KILL SESSION ''' || S.SID || ', ' || S.SERIAL# ||
       ''';' AS KILL_COMMAND,
       s.USERNAME,
       s.MACHINE,
       s.PREV_EXEC_START
  from v$locked_object l, dba_objects o, v$session s, v$process p
 where l.object_id = o.object_id
   and l.session_id = s.sid
      -- and object_name='BDC_FWSX'
   and s.paddr = p.addr
 order by s.PREV_EXEC_START
 解锁：执行KILL_COMMAND中的语句
 ALTER SYSTEM KILL SESSION '304, 3581';