Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-12850

could not allocate parallel execution servers on all specified instances: desired_num needed, actual_num allocated
  • desired_num: The desired number of parallel execution servers.
  • actual_num: The actual number of parallel execution servers.

Cause

When executing a statement on a GV$ fixed view, one or more instances failed to allocate a parallel execution server to process the statement.


Action

Check trace output for instances on which parallel execution servers failed to start. GV$ query can only proceed if parallel execution servers can be allocated on all instances.