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?
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
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.