Hi,
My server have 4 CPUs, when I try some complex queries I found that CPU usage is only 25%, so only 1 CPU is working.
SQL> SHOW PARAMETER cpu;
cpu_count integer 4
parallel_threads_per_cpu integer 2
I saw this post:
1637120
I have two difference instances running. I have got the problem with the second instance, and it has shared_server=1, so I change its value to 0.
But it didn´t solve the problem.
Is there any other parameter I have to change ?
thank you!
Message was edited by:
pollopolea
Message was edited by:
pollopolea