I don't think that increasing the db_writer_processes will help. NT is, as noted elsewhere, multi-threaded. Increasing the db_writer_processes will not start a new process.
My experience with Oracle on NT is that when the CPU is pegged at 100% it is because the OS is constantly writing and fetching the contents of RAM to the swapfile. Meghraj Thakkar from Quest has a good paper on running Oracle 9i on Windows NT/2000. A search on Yahoo will probably find it for you. I don't have the URL. The following points are taken from that paper. Decrease the size of SGA so that all of the SGA and the OS will fit in physical RAM. This will decrease the use of the swapfile. Choose "Maximum throughput for network applications" in the control panel. Oracle does it's own memory management. Trying to let Windows memory manage on top of that adds to swapfile use. >From the Services panel, disable all unneeded services. This includes License logging service, plug and play, remote access autodial manager, remote access connection manager, remote access server, and telephony service. You should not touch alerter, browser, eventlog, messenger, Oracle ServiceXXXX, Oracle TNSListener, Server, spooler and workstation. If you have 9i, set PRE_PAGE_SGA = TRUE. This tells Windows to keep the SGA in physical memory (RAM) as much as possible. It will get paged out --- that's the nature of Windows --- but not as often. Windows does IO buffering. However, Oracle does its own IO buffering apart from the OS. Performance can be increased and more of the RAM made available to the SGA by using REGEDIT and editing the registry. Go to \HKEY_LOCAL_MACHINE\Control\SessionManager\MemoryManagement and setting LargeSystemCache to 0. Be sure to back up the Registry before editing. HTH -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day 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).
