In our sql statements , we are using PARALLEL_MIN_PERCENT = 100 for getting 100% parallel slaves.
But sometimes,it fails with ORA-12827.
if we remove PARALLEL_MIN_PERCENT = 100 , then obviously the query execution time will increase.
How to make sure that the query always get 100% parallel query slaves?
Is there any work around for this other than removing or changing PARALLEL_MIN_PERCENT?
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.