博客

select s.sid,
       s.machine,
       o.object_name,
       l.oracle_username,
       l.locked_mode,
       ‘ALTER  SYSTEM  KILL  SESSION  ”’ || s.sid || ‘,  ‘ || s.serial# ||
       ”’;’ Command
  from v$locked_object l, v$session s, all_objects o
 where l.session_id = s.sid
   and l.object_id = o.object_id

SELECT   username, machine, program, status, COUNT (machine) AS
连接数量
    FROM v$session
GROUP BY username, machine, program, status
ORDER BY machine;