Oracle 檢視鎖,檢視連接配接數

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;