Re: # of CPUs supported

"Tom Dyess" <tdyess_at_dyessindustries.com> wrote in message news:<dzz38.423101$oj3.80061815_at_typhoon.tampabay.rr.com>...
> Joe,
>
> I'm not POSITIVE, but I think that's dependant on the OS level and not
> the application (Oracle) level. I.e. if Solaris supports 64 processors,
> Solaris will thread them and not Oracle. The question arises in the
> /*+parallel hint and to whether or not there is a maximum there.
>
> Tom
> www.oraclepower.com
>
> "Joe Yong" <flyingbuick_at_yahoo.com> wrote in message
> news:6ad26002.0201181040.3598ce1_at_posting.google.com...
> > Hi all,
> > I did try searching on oracle.com and the existing threads here but
> > couldn't get a definitey answer so here's the question.
> >
> > 1. How many CPUs are supported by Oracle9i STANDARD edition on
> > a. Windows 2000 Server
> > b. Windows 2000 Advanced Server
> > c. Windows 2000 Datacenter server
> >
> > 2. What about ENTERPRISE edition?
> >
> > 3. Is this a "hard" limit (ie. Oracle will not recognize/utilize
> > additional CPUs) or is it a "soft" limit (governed only by the license
> > agreement)?
> >
> > If you can provide a link where specific info on this is available,
> > that'd be great!
> >
> > Thanks much.
> >
> >
> > joe.
> >

I beleive it is 4 cpus except Oracle has made some changes to the documentation
or increased it with the coming of 9i.It will probably be a soft limit from your definition but are you ready to risk?If you are in production you may be a little bit more cautious. There should be some information on this website of oracle http://technet.oracle.com/doc/oracle8i_816/server.816/a76962/ch4.htm#73594

Hope that helps
Michael Tubuo Ngong(DBA) Received on Wed Jan 23 2002 - 12:37:56 CST