Sessions

1 Sessions anzeigen

SELECT sid, STATUS, PROCESS, PROGRAM, LOGON_TIME
  FROM v$session 
  WHERE sid > 1;

oder

SELECT SID,SERIAL#,STATUS,SERVER
   FROM V$SESSION
   ORDER BY sid;

2 Session abbrechen

ALTER SYSTEM KILL SESSION '<SID>,<SERIAL#>';

z.B.

ALTER SYSTEM KILL SESSION '230,55988';