CPU utilization

[malru]

Hi,

In my AIX server, we're having 5 cPUs but it seems only one CPU utilization is more
& others are low even when there is situation that all the CPUs should be utilized for
an activity, but it's not happening. Is there any ORACLE init.ora parameters do we've
to set for multiple CPU utilization? Expecting your valuable suggesstions on this issue?

Thanks..

[davey23uk]

no, the os deals with scheduling and a process can only go on one cpu so if you have one process doing a lot of work , only one cpu will be used

[Bore]

Davey is right as usual, but there is something u can do. It is called parallelization.
If the load comes mainly from one large query, u will face that problem. Then Oracle supports (in EE) parallel queries, which means u can split the query and the session to use several PQ slave processes to parallel scan,join, order whatever the data, hence to utilize all the CPUs

Regards

[malru]

Thanks Bore,

Do i've to set any init.ora parameters to use all the CPUs by means of
parallelization?

[rramesh16]

If u r using 10g the parameter called parallel_max_servers this is for parallelization of query. Check the usage of this parameter in web before going to use

[pando]

to use all CPU you must parallelize your SQL statements which is a good idea in Data Warehouse and a very BAD idea in an OLTP system

[Bore]

Support PANDO. Generally u say nothing about the load. What generates it? It is very dependent on that how will u parallelize the process.

[malay_biswal]

I would suggest to do execute top command to check the top CPU intensive processes. Then check if it's oracle process. If oracle drill down what query is that, then you may use the Parallel hint. If it's not Oracle process not much you can do, may raise SR.