Oracle Sessions: Unterschied zwischen den Versionen

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

Version vom 3. September 2020, 08:44 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';