Benutzer-Werkzeuge

Webseiten-Werkzeuge


dba:kill_disconnect_session

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen RevisionVorhergehende Überarbeitung
Letzte ÜberarbeitungBeide Seiten der Revision
dba:kill_disconnect_session [2015/01/02 19:27] – [Eine gekillete Session in der DB wiederfinden] gpipperrdba:kill_disconnect_session [2015/01/07 11:15] – [Eine gekillete Session in der DB wiederfinden] gpipperr
Zeile 149: Zeile 149:
   * PID - Oracle process id.   * PID - Oracle process id.
  
 +
 +
 +<code sql>
 +ttitle left "Processes without entries in the v$session" skip 2
 +
 +
 +column process_id format a8     heading "Process|ID"
 +column inst_id    format 99     heading "Inst|ID"
 +column username   format a8     heading "DB User|name"
 +column osusername   format a8   heading "OS User|name"
 +column pname       format a8    heading "Process|name"
 +
 +select --p.inst_id  
 +      to_char(p.spid) as process_id
 + , p.username as osusername
 + , p.pname
 + , p.program
 +from v$process p
 + where p.program!= 'PSEUDO' 
 +   and p.addr not in (select gv.paddr from v$session gv)
 +   and p.addr not in (select bg.paddr from v$bgprocess bg)
 +   and p.addr not in (select ss.paddr from v$shared_server ss)
 +--order by p.inst_id 
 +/  
 +  
 +-- new column creator_addr in v$session!
 +
 +ttitle left  "get the prozess of a killed session with the help of the creator_addr" skip 2
 +
 +
 +select --p.inst_id  
 +      to_char(p.spid) as process_id
 + , p.username as osusername
 + , p.pname
 + , p.program
 +from v$process p
 + where p.addr in (select gv.creator_addr from v$session gv where status in ('KILLED') )
 +/
 +
 +ttitle off
 +</code>
  
    
dba/kill_disconnect_session.txt · Zuletzt geändert: 2015/01/16 16:23 von gpipperr