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 AUGUST 11, 2020
Applies to:Oracle TimesTen In-Memory Database - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
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:
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.
Problem occurs only when NLS_SORT=BINARY_CI (case-insensitive) is enabled, i.e.,
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