| need to shutdown/startup DB after increasing number of CPU ? [message #98038] |
Tue, 09 December 2003 20:58  |
Mat
Messages: 22
Registered: November 2001
|
Junior Member |
|
|
Hi there,
Do I need to shutdown and startup my database after installing new CPUs to make Oracle use all the CPUs ?
We've got 6 CPUs and we would like to add 6 CPUs more, do we need to restart our Oracle database for Oracle Server to use the 12 CPUs ?
Thanks !
|
|
|
|
| Re: need to shutdown/startup DB after increasing number of CPU ? [message #98041 is a reply to message #98038] |
Mon, 15 December 2003 03:20  |
Frank Naude
Messages: 4581
Registered: April 1998
|
Senior Member |
|
|
Hi,
My guess is that Oracle will immediate start using all the available CPUs. Remember, it is the OS that schedules work and not the DB. Nevertheless, you may want to restart the DB to "refresh" the CPU_COUNT initialisation parameter. This parameter is used for optimising workload and tuning memory structures.
You may also want to query the X$KVII view to see how many CPUs Oracle thinks it is using.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
