My Oracle Support Banner

Error ORA-12801 and ORA-32696 from parallel GROUP BY with no aggregates or COUNT(DISTINCT) (Doc ID 1139393.1)

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 10.2 to 11.1
Information in this document applies to any platform.
Reviewed 18-Nov-2011.


While querying a parallel group-by query with no aggregates,
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


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

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.

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