Hi,
We have a data warehouse running on oracle 11.2.0.3 and sometimes mentioned by other developers that parallel query servers being exhausted.
Had a look at database at quiet times e.g only 3 queries running
SELECT * FROM v$px_process_sysstat;
and can see 60 servers busy.
Notice in v$parameter the values of parallel_min and max servers are both ste at 60.
Any good reason why both would be set at same value?
If trying to monitor parallel execution it would seem if both have same value then if any query executing then none would show as available?
parallel_degree_policy set to manual and oracle will be deciding based upon the degree of parallelism set on the various tables - most times fine but on occasion queries queue up.
Thanks