I have a java program which runs in multithread and interact with DB(Oracle).
Th DB Server side only a few of the CPUs are in action rest are all resting. Is there any parameter in the DB (Oracle) which shall be set so that all the CPUs share the load in parallel?
The below parameters I see as a result of "show parameters", will investigate what are these for.
parallel_threads_per_cpu integer 2
If any one of you have an idea on this kindly do share.