ORA 7445 [qks3tAllocIDL] While Running a SELECT Statement With PARTITION and Using Nested Cursor
Last updated on SEPTEMBER 08, 2017
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [Release 11.2 to 12.1]
Information in this document applies to any platform.
In 126.96.36.199 database and above, the following error appears during a select statement:
ORA-07445: exception encountered: core dump [qks3tAllocIDL()+525] [SIGSEGV] [ADDR:0x20] [PC:0x1786101] [Address not mapped to object] 
The call stack contains:
qks3tAllocIDL qks3tAllocIDL qks3tAllocIDL opitca kksFullTypeCheck rpiswu2 kksLoadChild kxsGetRuntimeLock
The failing statement contains a WITH query sub-factoring and a nested cursor, similar to:
SELECT * FROM TABLE ..... (CURSOR (WITH...))...
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