Archive for November, 2008

This site is not tested with Internet Explorer(c) :)

Have you heard of the “Not tested in IE initiative“?

If your site matches this criteria, use one of these images there.


By Martin Klier in Community,Humor  .::. (Add your comment)

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 case, be careful to issue the stop command on the correct instance!

Furthermore, the command “ALTER SYSTEM SET DISPATCHERS=” has a mad behaviour, if you are using a multi-threaded server setup and you are configuring the DISPATCHERS init parameter in the appropriate way. Let me give you an example (mind to remove the CR/LF, alter system won’t like them):
Read more…

By Martin Klier in Oracle  .::. (Add your comment)

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.