Hi,
Using oracle 11.2.0.3 and on occasion if have many multiple parallel queries running at once, some of these are being downgraded to run in serial due to parallel_max_servers being reached.
We have 6 cpu and 2 parallel-threads per cpu.
On these occasions, the server team have advised machine cpu is not being exhausted and looking at system can often see is i/o bound which made me think if could increase the number of threads per cpu maybe could get more throughput.
If increase this, how can we determine what should increase it to. Saw some documentation which suggested if system i/bound should increase and also can it be chnaged without a database bounce.
Thanks