Parallel Query fails ORA-600 [Kgeade_is_0] or ORA-0 on RAC
(Doc ID 752967.1)
Last updated on OCTOBER 01, 2019
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 19-Aug-2010***
***Checked for relevance on 27-Apr-2012***
Oracle Server Enterprise Edition - Version: 10.1.0.2
Query against gv$ views on RAC system like
select INST_ID, NAME, VALUE
where NAME ='parallel_threads_per_cpu';
Would fail with
ERROR at line 1:
ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 1
ORA-12801: error signaled in parallel query server PZ99, instance xxxx
ORA-00000: normal, successful completion
or instead of the ORA-0 with a ORA-600 [Kgeade_is_0]
There was a internal bug fix that a ORA-0 should be reported as ORA-600 [Kgeade_is_0].
And this was merged into the 10.2.0.4 patchset.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document