Message-ID: <F001.00454022.20020430120337@fatcity.com>
Date: Tue, 30 Apr 2002 12:03:37 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Eric D. Pierce" <PierceED@csus.edu>
Subject: Meghraj Thakkar - Quest - Oracle 9i on Windows NT/2000 / Re: ORACLE-L Digest -- Volume 2002, Number 120
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-type: text/plain; charset=US-ASCII
Content-transfer-encoding: 7BIT

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: Jared.Still@radisys.com
>  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 <tday6@csc.com>
> Sent by: root@fatcity.com
> 04/29/2002 06:59 AM
> Please respond to ORACLE-L
> 
> 
>         To:     Multiple recipients of list ORACLE-L
>         <ORACLE-L@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
> 
> 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@csc.com
> 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Eric D. Pierce
  INET: PierceED@csus.edu

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@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).