My Oracle Support Banner

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 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:


Query against gv$ views on RAC system  like

from gv$parameter
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 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.