Re: Background processes on NT

From: Brett Neumeier <random_at_interaccess.com>
Date: 1997/12/10
Message-ID: <66mmfq$fbl$1@nntp3.interaccess.com>#1/1

Gilles HARO (g_haro_at_yahoo.com) wrote:

: Have a look a the ODP article 'difference between UNIX and NT'.
: It gives details n how Oracle runs on an NT system.
: The idea is that everething runs into a sigle process which is divided into
: threads.

This is in fact the case.

: Chuck Hamilton a écrit dans le message <3474032c.8275147_at_news.dvol.com>...

: >I recently inherited an Oracle7 NT database to administer. It looks
: >like it's running everything (lgwr, pmon, dbwr, etc.) under a single
: >process. Is this the preferred configuration under NT? How can I split
: >it up to multiple processes?

In fact it is the only possible configuration under NT. As I understand it, Windows NT has no way to allocate memory segments that can be shared among different processes. As a result, in order for all the background processes (and oracle server processes) to access the SGA, they must be one actual process as far as NT is concerned, so that they can share a single address space.

One drawback of this is that, if you are using snapshots and they hang periodically (as ours do), you cannot simply kill the SNP process and wait for PMON to resuscitate it. In 7.2.2.4.13 and later this is resolved by adding a program "orakill.exe" which allows users to stop threads within an Oracle service.

-- 
-bn
random_at_interaccess.com	(PGP 2.6.2 public key available on request)
"There is no .signature -- only ZUUL!"

Received on Wed Dec 10 1997 - 00:00:00 CST