Database Error Messages

OCI-12832

Cannot allocate parallel execution servers on all specified instances

Cause

After executing a query on a global V$ fixed view, one or more instances are failing to allocate a parallel execution server to process query.


Action

To allow results to be returned by successfully allocated parallel execution servers, execute the ALTER SESSION SET ALLOW_PARTIAL_SN_RESULTS=TRUE statement, or check the parameters of the instances.