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 <tday6_at_csc.com>
Sent by: root_at_fatcity.com
04/29/2002 06:59 AM
Please respond to ORACLE-L  

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        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
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: tday6_at_csc.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).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Jared.Still_at_radisys.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).