Hi,
This might be a stupid question, but have to ask it.
I have 135 open sessions to the DB - all with update/delete on huge tables which could process thousands/millions of records. The Oracle processes in the server uses just above 1.5 (1-3) % of CPU. Total CPU utilization is not more than 35-40%.
Out of 16 CPUs, only 1 or 2 CPUs are under utilization - all others are in idle status.
Can I look at optimizing this? Is there a cap for CPU utilization for an oracle process to go on (may be for disk read/write)? Basically I want to utilize the entire CPU available and finish the job as soon as possible - can that be done?
Please help.