OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » no of cpu

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

no of cpu [message #61174]

Fri, 02 April 2004 03:54

muncious
Messages: 5
Registered: March 2004

Junior Member

Hi,
I can i know numbers of cpu my database using.
And What is use of using mlutiple cpu does it affect performance issues.

Report message to a moderator

Re: no of cpu [message #61175 is a reply to message #61174]

Fri, 02 April 2004 05:30

Thiru
Messages: 1089
Registered: May 2002

Senior Member

-- Oracle picks up the info from the OS
SQL> show parameter cpu_count

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cpu_count integer 6

-- On a Sun system,the number of online CPUs
SQL> !psrinfo&#124grep on-line&#124wc -l
6

Yes,Performance is affected by processing power,number of cpus and other factors.

-Thiru

Report message to a moderator

Re: no of cpu [message #61213 is a reply to message #61174]

Mon, 05 April 2004 16:39

RR
Messages: 19
Registered: October 2001

Junior Member

select name, isdefault, value from v$parameter
where name = 'cpu_count';

Report message to a moderator

Previous Topic:	Oracle universal installer error
Next Topic:	why is it giving tns-protocol error?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:40:29 CDT 2024