HOWTO : Resolve TimesTen Error 6221: Temporary data partition free space insufficient to allocate N bytes of memory When NLS_SORT=BINARY_CI Is Used
Last updated on JULY 05, 2017
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.,
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