My Oracle Support Banner

12c: ORA-07445: Exception Encountered: Core Dump [msqcol()+1698] for SQL Tuning Advisor (Doc ID 2020916.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Standard Edition - Version 12.1.0.1 and later
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

Alert log reports next error during automatic sql tuning advisor run:

Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
...
ORA-07445: exception encountered: core dump [msqcol()+1340] [SIGSEGV] [ADDR:0x10] [PC:0x279C19C] [Address not mapped to object] []


The trace file shows characteristics like:

----- Current SQL Statement for this session (sql_id=bg3b1a8yb4xc8) -----
/* SQL Analyze(225,1) */ Select dpwi.PROD_ID,dpwi.PROD_NAME,dpwi.ING_ID,dpwi.CONCENTRATION,dpwi.COLOUR,dpwi.HAZARDOUS,dpwi.STD_REC,dpwi.R_PHRASES,dpwi.POISON_SCHEDULE,dpwi.UN_NUMBER,dpwi.DG_CLASS,dpwi.LAST_REVIEWED,dpwi.MANUFACTURER,dpwi.ING_TOCONCENTRATION,dpwi.STATUS,dpwi.BP_ISNORELEASE,dpwi.GHS_CODES,dpwi.ISSUE_DATE From   CADE.DE_PRODS_WITH_ING  dpwi   Where  ( dpwi.ING_ID = :0) order by dpwi.PROD_NAME

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
0x10ef426b0     12818  package body SYS.DBMS_SQLTUNE_INTERNAL
0xcaa91d20         7  SYS.WRI$_ADV_SQLTUNE
0x87b15490       602  package body SYS.PRVT_ADVISOR
0x87b15490      2679  package body SYS.PRVT_ADVISOR
0x10b419bf8       241  package body SYS.DBMS_ADVISOR
0x1094ceb68       937  package body SYS.DBMS_SQLTUNE
0x107e58110        19  anonymous block

----- Call Stack Trace -----
... msqcol msqopnws msqsellst msqsel qksdsAppendFroElem qksdsEInitCtx kkoatVerifyEst kkeAdjJoinPrefCard kkejcd kkojnp kkocnp kkooqb kkoqbc apakkoqb apaqbdDescendents
...

  

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.