RE: CPU Pegged at 100%

Thanks Thomas for sending this to the list.

Lisa Koivu
Oracle Database Baby Oven
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063

> -----Original Message-----
> From: Thomas Day [SMTP:tday6_at_csc.com]
> Sent: Monday, April 29, 2002 9:59 AM
> To: Multiple recipients of list ORACLE-L
> 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: Koivu, Lisa
  INET: lisa.koivu_at_efairfield.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).