Meghraj Thakkar - Quest Oracle 9i on Windows NT/2000
http://www.oracle.com/pls/oow/oow_user.show_public?p_event=6&p_type=session&p_id=11958 - Whitepaper: http://www.oracle.com/pls/oow/oow_user.download?p_event_id=6&p_file=W11958.zip (expands to "105.doc") | Some parts of this paper have been extracted from the books | "Teach Yourself Oracle8i on Windows NT in 24 Hours" by Megh Thakkar | (ISBN: 0672315785) and | "e-Business for the Oracle DBA" by Megh Thakkar (ISBN: 0672321475) - Presentation; http://www.oracle.com/pls/oow/oow_user.download?p_event_id=6&p_file=P11958.zip (expands to "105.pps") ORACLE-L Digest -- Volume 2002, Number 120 > ------------------------------ > > From: [EMAIL PROTECTED] > Date: Mon, 29 Apr 2002 11:29:55 -0700 > Subject: RE: CPU Pegged at 100% > > Thomas, > > If you could locate that paper, we would all be grateful. > > I have been unable to find it. > > Thanks, > > Jared > > > > > > Thomas Day <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 04/29/2002 06:59 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> cc: Subject: RE: CPU Pegged at 100% > > > > 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 > > 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] > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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).
