Oracle Sessions: Unterschied zwischen den Versionen

Aktuelle Version vom 19. Februar 2021, 22:34 Uhr

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;

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

z.B.

ALTER SYSTEM KILL SESSION '230,55988';

@@ Zeile 1: / Zeile 1: @@
-{{DISPLAYTITLE:EDI Auto Importer|noerror}}
+{{DISPLAYTITLE:Sessions|noerror}}
+=== Sessions anzeigen ===
 <pre>
 SELECT sid, STATUS, PROCESS, PROGRAM, LOGON_TIME
@@ Zeile 11: / Zeile 12: @@
     FROM V$SESSION
     ORDER BY sid;
+</pre>
+=== Session abbrechen ===
+<pre>
+ALTER SYSTEM KILL SESSION '<SID>,<SERIAL#>';
+</pre>
+z.B.
+<pre>
+ALTER SYSTEM KILL SESSION '230,55988';
 </pre>