ORA-32696: HTI: No free slot

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

Applies to:

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


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


The cause of this problem has been identified in Bug 8394351. It is caused by the adaptive fetch is not
getting kicked in for parallel group-by queries without aggregates.


This is fixed for RDBMS 11.2 release.
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.


Niciun comentariu:

Trimiteți un comentariu