My Oracle Support Banner

ORA-7445[MSQCOL] When Running SQL Tuning Advisor (Doc ID 2122647.1)

Last updated on JUNE 18, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

When SQL Tuning task is executed, the error ORA-07445[msqcol()] is reported and PL/SQL call stack looks like:
 
 ----- PL/SQL Stack -----
 ----- PL/SQL Call Stack -----
 object line object
 handle number name
 0x353dad990 11829 package body SYS.DBMS_SQLTUNE_INTERNAL
 0x357eb5a68 7 SYS.WRI$_ADV_SQLTUNE
0x353dce508 601 package body SYS.PRVT_ADVISOR
0x353dce508 2658 package body SYS.PRVT_ADVISOR
0x351d37fc0 241 package body SYS.DBMS_ADVISOR
0x357e8bf98 837 package body SYS.DBMS_SQLTUNE
0x35bd8d6e8 1 anonymous block

The call stack looks like:

... msqcol <- msqopnws <- msqsellst <- msqsel <- msqsub <- msqtnm <- msqfrmcl <- msqsel <- msqsub ...

 

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.