Home » RDBMS Server » Server Administration » CPU_COUNT (10g, 11gR1 and 11gR2)
CPU_COUNT [message #602911] Tue, 10 December 2013 06:05 Go to next message
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?
Re: CPU_COUNT [message #602916 is a reply to message #602911] Tue, 10 December 2013 06:40 Go to previous message
John Watson
Messages: 7608
Registered: January 2010
Location: Global Village
Senior Member
Just do a couple of tests:
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
Previous Topic: To provide privilege on utlrp.sql to users
Next Topic: Creating new tablespaces in 10gR2
Goto Forum:
  


Current Time: Tue Oct 16 03:00:36 CDT 2018