My Oracle Support Banner

ORA-07445 [qkaWNPushdown()+255] Reported for Select Statement in 12.1.0.2 (Doc ID 2427114.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

The following error is periodically reported in a 12.1.0.2 database:

ORA-07445: exception encountered: core dump [qkaWNPushdown()+255] [SIGSEGV] [ADDR:0x18] [PC:0x7FF104F] [Address not mapped to object] []

The error is reported for:

select /*+ parallel(2) */ prod_name 
 from (
        select prod_name, 
 	      row_number() over (order by dimension(null)) rn 
        from products
      )  where rn <= 5;

and the following call stack is generated:

----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)    
-------------------- -------- -------------------- ----------------------------
qkaWNPushdown qkawn qkaqkn qkadrv qkadrv opitca kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0
kksParseCursor opiosq0 kpoal8 opiodr  ttcpip opitsk opiino opiodr opidrv sou2o opimai_real ssthrdmain main

 

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.