About

Martin Klier

usn-it.de

Oracle: How to stop a (MTS) dispatcher process – mad behaviour of ALTER SYSTEM

Manually stopping a dispatcher process is one of the things I have to look up each time, since it’s needed not that often. And, the word “dispatcher” does not appear in the command line! 🙂 alter system shutdown immediate ‘D000’; where “D000” is the dispatcher process name selected from v$dispatchers or gv$dispatchers. (In the latter […]

read more