HOWTO : Resolve TimesTen Error 6221: Temporary data partition free space insufficient to allocate N bytes of memory When NLS_SORT=BINARY_CI Is Used (Doc ID 789614.1)

Last updated on JULY 05, 2017

Applies to:

Oracle TimesTen In-Memory Database - Version 7.0.5.0.0 and later
Information in this document applies to any platform.

Symptoms

Customers may encounter situations where a query performing an order-by or other sort operation completes with relatively little temporary space required when NLS_SORT value is either not enabled or set to BINARY. However, when NLS_SORT is altered to BINARY_CI, that same query fails and exhausts all available temp space.

The following errors may be returned:

802: Data store space exhausted
6221: Temporary data partition free space insufficient to allocate 20212 bytes of memory

 The query continues to fail with the TT802 and TT6221 space errors even when temporary space in the datastore is greatly increased.

Changes

Problem occurs only when NLS_SORT=BINARY_CI (case-insensitive) is enabled, i.e.,

Alter Session set NLS_SORT=BINARY_CI;

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms