Oracle-L: RE: SMP on windows2000

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Thu, 25 Jul 2002 20:23:20 -0800
Message-ID: <F001.004A300F.20020725202320@fatcity.com>

I found a workaround, I set the following init.ora parameters:

Cpu_count = 2 or 4, depending on the Win2K server Parallel_min_servers = 2 or 4, depending on the server Parallel_max_servers = 10 or 12, depending on the server

Dbms_stats run in parallel with degree=>4 seems to keep the CPUs busy.

I basically wanted to speed up dbms_stats, I have a job I wish to run early every morning and I don't want it to interfere with user activity.

For some databases CPU shoots up to 85% on a machine with 4 CPUs, nice to see it being used.

On one database (data warehouse) CPU usage never seems to climb much higher than about 15% during dbms_stats, not sure why that is at this point, will double-check the pfile to ensure it matches that of the other db's.

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systèmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Région des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

-----Original Message-----

Sent:	Thursday, July 25, 2002 10:14 PM
To:	Multiple recipients of list ORACLE-L
Subject:	RE: SMP on windows2000

iTAR resulted in no info so far. Oracle Tech Support is basically saying all their really good info is "confidential".

some analysis of overall industry issues w/ SMP:

http://www.aceshardware.com/read.jsp?id=45000350

(linked from http://2cpu.com)

latest URL dump -----------

http://2cpu.com
-

http://www.aceshardware.com/read.jsp?id=45000350
-

http://www.winntmag.com/Articles/Index.cfm?ArticleID=7486
-

http://www.ultratech-llc.com/KB/?File=SMP.TXT
-

http://www.ultratech-llc.com/KB/?File=SMPOS.TXT
-

http://www.microsoft.com/windows2000/techinfo/howitworks/default.asp
-

http://www.microsoft.com/mspress/books/sampchap/4354.asp (
linked from http://www.microsoft.com/mspress/books/4354.asp )
-

http://developer.intel.com/technology/hyperthread/
-

http://www.microsoft.com/windows2000/server/evaluation/performance/reports/h yper
thread.asp
( http://www.microsoft.com/windows2000/docs/hyperthreading.doc )
-

http://support.microsoft.com/default.aspx?SCID=KB;EN-US;Q234558
-

(
general/introductory material only:
)
http://www.2cpu.com/OSs/Windows/win2kintropart1/Win2kintrop1.html
-

http://2cpu.com/How-To/article2.htm
-

http://2cpu.com/FAQ/2cpusmpfaq.htm

Original Message:

Date: Thu, 25 Jul 2002 10:13:49 -0800
To: ORACLE-L_at_fatcity.com

I've been wondering same, logged an iTAR. Will keep you in the loop.

background (same old crap, sorry, nothing specific):

http://www.winntmag.com/Articles/Index.cfm?ArticleID=7486 ....

mail2web - Check your email from the web at http://mail2web.com/ .

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: emopierc_at_pacbell.net
INET: emopierc_at_pacbell.net

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: Boivin, Patrice J
INET: BoivinP_at_mar.dfo-mpo.gc.ca

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