My Oracle Support Banner

ORA-7445 [kditpin()+20] Error Occurs Along With ORA-1652 When Running Select Statement with Order By (Doc ID 1949027.1)

Last updated on OCTOBER 08, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

When running SELECT statement with ORDER BY clause, ORA-7445 [kditpin()+20] error occurs along with ORA-1652

SQL statement:

SELECT A.INSTTSN,
  A.INSTTID,
  A.INSTTNM, NVL(NEW_ADRES,A.ADRES) ADRES ,
  A.UPPERINSTTSN,
  A.INSTTSTTUS,
  A.BESTINSTTSN,
  A.INSTTTYID
 FROM <table name>
 WHERE INSTTSTTUS = 'Y'
  AND INSTTTYID = :1
  AND UPPERINSTTSN <> 0
  AND INSTTNM LIKE '%' || :2 || '%'
 START WITH A.UPPERINSTTSN=0
 CONNECT BY PRIOR A.INSTTSN = A.UPPERINSTTSN
 ORDER SIBLINGS BY A.INSTTSORTORDR, A.INSTTNM
                                                                                            
ORA-1652: unable to extend temp segment by 128 in tablespace                 <temp tablespace name>
Errors in file ...<full path & file name>.trc  (incident=388914):
ORA-07445: exception encountered: core dump [kditpin()+20] [SIGSEGV] [ADDR:0x0] [PC:0x103E4B674] [Address not mapped to object] []
Incident details in: ... <full path & file name>.trc


The call stack in the incident trace file written by the error contains the following functions:

kditpin <- kgbtder <- kgbtdes <- stsTmpIxDestroy <- stsend <- sorcls <- qercbiFetch <- qerflFetchOutside

 

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!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.