OraFAQ Forum: Server Administration » CPU

Home » RDBMS Server » Server Administration » CPU_COUNT (10g, 11gR1 and 11gR2)

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

CPU_COUNT [message #602911]

Tue, 10 December 2013 06:05

BlackEagle
Messages: 8
Registered: December 2013
Location: India

Junior Member

Hi!

Is CPU_COUNT not sated by default in 10g and 11gR1?
And automatically sated at instance startup in 11gR2?

Is it correct?

Report message to a moderator

Re: CPU_COUNT [message #602916 is a reply to message #602911]

Tue, 10 December 2013 06:40

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

Just do a couple of tests:

Code: [Select all] [Show/ hide]

orclz>
orclz> show parameter cpu_count

NAME                                 TYPE       VALUE
------------------------------------ ---------- ----------------------------
cpu_count                            integer    4
orclz> alter system set cpu_count=2 scope=memory;

System altered.

orclz> show parameter cpu_count

NAME                                 TYPE       VALUE
------------------------------------ ---------- ----------------------------
cpu_count                            integer    2
orclz> alter system set cpu_count=6 scope=memory;
alter system set cpu_count=6 scope=memory
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-02097: parameter cannot be modified because specified value is invalid


orclz>

that was release 12.1. You may find that release 10.x behaves differently: the effect of the parameter changes a bit in release 11.something, you need to read up on "instance caging" and the Resource Manager

Report message to a moderator

Previous Topic:	To provide privilege on utlrp.sql to users
Next Topic:	Creating new tablespaces in 10gR2

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 08:36:46 CDT 2025