Meghraj Thakkar - Quest Oracle 9i on Windows NT/2000
http://www.oracle.com/pls/oow/oow_user.show_public?p_event=6p_type=sessionp_id=11958
-
Whitepaper:
http://www.oracle.com/pls/oow/oow_user.download?p_event_id=6p_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=6p_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
Service, 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).