Parallel slave failing with ORA-12850 with parallel_degree_policy set to AUTO
(Doc ID 2663486.1)
Last updated on MARCH 12, 2021
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
Database level sql queries failng with ORA-12850 while parallel_degree_policy set to AUTO.
SQL> select * FROM all_tab_statistics
ERROR at line 2:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 1 allocated
parallel_degree_policy = auto <<---
parallel_degree = 2
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!