RE: SMP on windows2000

Pat,

Looks interesting! Where/how did you find that stuff? :)

regards,
ep

On 25 Jul 2002 at 20:23, Boivin, Patrice J wrote:

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

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