dba:kill_disconnect_session
Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
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] gpipperr | dba: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 " | ||
+ | |||
+ | |||
+ | column process_id format a8 | ||
+ | column inst_id | ||
+ | column username | ||
+ | column osusername | ||
+ | column pname | ||
+ | |||
+ | 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!= ' | ||
+ | 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" | ||
+ | |||
+ | |||
+ | 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 (' | ||
+ | / | ||
+ | |||
+ | ttitle off | ||
+ | </ | ||
dba/kill_disconnect_session.txt · Zuletzt geändert: 2015/01/16 16:23 von gpipperr