Re: CPU_COUNT doesn't change after upgrade

From: Erik Trolle <erik_trolle_at_hp.com>
Date: Mon, 3 Jan 2000 10:26:42 +0800
Message-ID: <84p1an$frh$1@web1.cup.hp.com>

I have in the past 10 years never seen a problem when changing this parameter. I have never seen any significant benefit from changing it either. So if Oracle recommends not to change the parameter, then the simplest approach is to follow their advice.

Your original question was whether all CPUs were utilized with parallel query. You need first configure parallel execution in init.ora with - parallel_max_servers
- parallel_min_servers
and similar. Note that you do not need Oracle Parallel Server!! since this is about using multiple machines with the same database

Once Parallel Execution is configured correctly it will always utilize all available CPUs, no matter how CPU_COUNT is specified.

Erik

Tommy Yuen wrote in message <84dglk$9af$1_at_hfc.pacific.net.hk>...
>Thanks for your information.
>
>But Oracle7 Server Reference Manual said that
>we should not change the parameter in init.ora!
>
>Is it safe to change it?
>
>Thanks,
>Tommy
>
>
>
>
Received on Sun Jan 02 2000 - 20:26:42 CST