Kev,
Trying to add multiple DBWR processes on NT is useless since NT uses asynch.
I/O. If you remember, all the Oracle processes (DBWR, LGWR, CKPT, ARCH,
etc.) run as threads under the oracle.exe process.
Multiple DBWR processes are definitely a Unix thing!
Also, here's something from MetaStink on the issue:
Oracle on NT only allows/needs a single database writer process (DBWR).
Multiple DBWRs on UNIX is not multiple "real" DBWRs which
all go scan for dirty buffers and write them to disk. It's really just one
"real" DBWR and some I/O slaves. The "real" DBWR tells the slave DBWRs to do
I/O.
On NT, there's really no need for this since async I/O and NT will
take care of all that for you. NT acts as the I/O slaves and the "real" DBWR
[1 DBWR thread] then checks the "slaves" to see if the I/O is done.
Melissa Holman
Oracle Support
Ed
Ed Haskins
Oracle DBA
Verizon Wireless
-----Original Message-----
Sent: Monday, June 04, 2001 11:56 AM
To: Multiple recipients of list ORACLE-L
Hi all,
I added db writer processes last week to try and improve performance
of one
of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle
actually started the additional db writer processes? I added
db_writer_processes to the init file, the instance started so I am assuming
that the db writer processes are working. But we all know what happens when
we assume something. Any ideas would be appreciated.
Sincerely,
Kevin Kostyszyn
DBA
Dulcian, Inc
www.dulcian.com
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Haskins, Ed
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
