Bug 8394351 ORA-32696 from a parallel GROUP BY with no aggregates or COUNT(DISTINCT)
|This issue is fixed in|
|Error ORA-12801 In Parallel Query Server P071 Running [ID 1139393.1]|
|Modified 28-JUL-2010 Type PROBLEM Status MODERATED|
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|
Applies to:Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 188.8.131.52 - Release: 10.2 to 11.1
Information in this document applies to any platform.
or for a parallel query with count(distinct), then the following errors occur:
ORA-12801: error signaled in parallel query server P071
ORA-32696: HTI: No free slot
getting kicked in for parallel group-by queries without aggregates.
The Patch 8394351 is available at top of RDBMS 10g and 11.1 for many platforms.
If it needs a fix for others platforms,
please contact Oracle Support and request assistance for the Bug 8394351 problem.