| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Database writer
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
kevin_at_dulcian.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Kostyszyn
INET: kevin_at_dulcian.com
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Mon Jun 04 2001 - 12:06:59 CDT
 |
 |