ORA-07445 [PC:0xF4C4] While Using a SELECT Query Involving ORDER BY (Doc ID 1998912.1)

Last updated on DECEMBER 30, 2015

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.3 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms

A query with group by and order by clause fails with the following error in the alert log:

ORA-07445: exception encountered: core dump [PC:0xF4C4] [SIGSEGV] [ADDR:0x2000000000] [PC:0xF4C4] [Address not mapped to object] []


The call stack from the trace file includes the following functions:

qkxrDo_Pvt qkxrDo qkexrXformOpn_Opt qkexrXformOpn qkexrXformOpn_Opt qkexrXformOpn qkxrXformRwo qersoAllocate qknRwsAllocateTree qknDoRwsAllocate IPRA IPRA qkadrv2Post qkadrv2 opitca kksLoadChild kxsGetRuntimeLock kksfbc kkspsc0 kksParseCursor opiosq0 opiosq ...

 

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