ORA-7445 [kdzdcol_agg_cols_imc_generic()+24] Is Raised when Querying INMEMORY MEMCOMPRESS Table
Last updated on DECEMBER 24, 2015
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 12.1]
Information in this document applies to any platform.
When querying a table with INMEMORY MEMCOMPRESS attribute, an ORA-3113 error may be returned to the session, while ORA-7445 error is reported in the alert.log.
User session may show:
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 8957
Session ID: 11 Serial number: 49894
The error in the alert log is like:
The call stack in the trace file shows functions like:
Meeting all of the following conditions may trigger this error.
- You have applied 22.214.171.124.5 Database Bundle Patch or later
- Session stacksize limit (ulimit -s) is fairly small, eg. 2048K
- Target table has INMEMORY MEMCOMPRESS attribute
- Query uses SUM() aggregate function
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