|
|
Re: ORA-12827: insufficient parallel query slaves available [message #483868 is a reply to message #483858] |
Thu, 25 November 2010 02:27 |
John Watson
Messages: 8922 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You statement is failing because it wants to use more parallel servers than are currently available. I would think that you have a hard-coded degree of parallelism, either with hints in the statement or in the DDL of the objects. The standard advice is don't do this, rather enable parallelism on the objects without specifying a degree, and enable automatic parallel tuning by setting the parallel_adaptive_multi_user parameter to TRUE. Then optimizer decide how many to use, depending on workload.
|
|
|
|
|
|
|