This content has been marked as final. Show 2 replies
Increase parallel_min_servers. What happens is as follows. At instance startup oracle starts parallel_min_servers processes to handle PQO (Parallel Query Option). Assume, for example parallel_min_servers = 4. Assume table has degree of parallelism 6. When you set PARALLEL_MIN_PERCENT = 100 you are requesting PQO to start 6 slave processes while only 4 are available.1 person found this helpful
When i replace PARALLEL_MIN_PERCENT = 100 by
the query takes the same time as before.
ALTER SESSION FORCE PARALLEL QUERY PARALLEL 16
What relation does this indicate?