Parallel Query fails ORA-600 [Kgeade_is_0] or ORA-0 on RAC
Last updated on MARCH 27, 2014
Applies to:Oracle Server - Enterprise Edition - Version 10.1.0.2 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms