Oracle Sessions: Unterschied zwischen den Versionen

Aus PPwiki
Wechseln zu: Navigation, Suche
Zeile 1: Zeile 1:
 
{{DISPLAYTITLE:Sessions|noerror}}
 
{{DISPLAYTITLE:Sessions|noerror}}
  
===Sessions anzeigen===
+
=== Sessions anzeigen ===
 
<pre>
 
<pre>
 
SELECT sid, STATUS, PROCESS, PROGRAM, LOGON_TIME
 
SELECT sid, STATUS, PROCESS, PROGRAM, LOGON_TIME
Zeile 14: Zeile 14:
 
</pre>
 
</pre>
  
===Session abbrechen===
+
=== Session abbrechen ===
 
<pre>
 
<pre>
 
ALTER SYSTEM KILL SESSION '<SID>,<SERIAL#>';
 
ALTER SYSTEM KILL SESSION '<SID>,<SERIAL#>';

Version vom 19. Februar 2021, 21:34 Uhr


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';