ORA 7445 [qks3tAllocIDL] While Running a SELECT Statement With PARTITION and Using Nested Cursor
(Doc ID 2022304.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.2 to 12.1]
Information in this document applies to any platform.
In 22.214.171.124 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...))...
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