2 Replies Latest reply: Nov 20, 2012 10:40 AM by Pandeesh RSS

    ORA-12827 insufficient parallel query slaves available


      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?