OraFAQ Forum: Unix » Solaris CPU's and Oracle server

Home » Infrastructure » Unix » Solaris CPU's and Oracle server

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Solaris CPU's and Oracle server [message #97475]

Mon, 03 June 2002 11:36

Toyn
Messages: 36
Registered: April 2001

Member

I have a SUN Solaris E450 with 4 CPU's running Oracle 8.0.5. Right now, I'm doing a mammoth amount of joins, and it's taking extraordinarily long. One of my managers noticed that only 1 out of the 4 CPU's was being utilized by the Oracle server. Is there anything in Oracle that will allow me to specify how many CPU's I can use? Conversely, is there anything in Solaris that will allow me to designate x amount of CPU's to the Oracle server? Thanks.

Report message to a moderator

Re: Solaris CPU's and Oracle server [message #97477 is a reply to message #97475]

Mon, 03 June 2002 12:49

Grant
Messages: 578
Registered: January 2002

Senior Member

CPU_COUNT=4 in your initSID.ora file.

Report message to a moderator

Previous Topic:	Re: diff. oracle 8i / 9i
Next Topic:	Re: Solaris CPU's and Oracle server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 21:17:33 CST 2025