ORA-32690: Hash Table Infrastructure ran out of memory (Doc ID 1505491.1)

Last updated on MARCH 03, 2017

Applies to:

Oracle Health Sciences InForm - Version 4.6.2.3 and later
Linux x86-64

Symptoms

 Complex Custom reports for very large trials which use Distinct when joining large tables could result in the following error - ORA-32690: Hash Table Infrastructure ran out of memory.

Changes

 Moving a reporting db from Windows 64-bit on Oracle 10.2.0.4 Patchset 3 to Linux X86-64 Oracle 10.2.0.4 Patchset 3 will result in the ORA-32690 error if running a complex custom report that joins large tables.

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