My Oracle Support Banner

Sql Tuning Advisor Fails With ORA-07445 [msqcol()+1698] [ACCESS_VIOLATION] (Doc ID 1641945.1)

Last updated on FEBRUARY 25, 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 Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Alert log reports next error for automatic sql tuning

ORA-07445: exception encountered: core dump [msqcol()+1698] [ACCESS_VIOLATION] [ADDR:0x10] [PC:0x144168A4C] [UNABLE_TO_READ] []


The trace file shows:

----- Current SQL Statement for this session (sql_id=200zhggbsk6cp) -----
/* SQL Analyze(22,1) */ SELECT ...
...
...
----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
000007FFF13902D8     11816  package body SYS.DBMS_SQLTUNE_INTERNAL
000007FFF13195F0         7  SYS.WRI$_ADV_SQLTUNE
000007FFF1498A70       587  package body SYS.PRVT_ADVISOR
000007FFF1498A70      2655  package body SYS.PRVT_ADVISOR
000007FFF13920A8       241  package body SYS.DBMS_ADVISOR
000007FFF151D9A8       821  package body SYS.DBMS_SQLTUNE
000007FFE8169B78         4  anonymous block

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

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!

In this Document
Symptoms
Changes
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.