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