ORA-07445 [MSQSUB()+32] Selecting from V$SQL_PLAN

ORA-07445 [MSQSUB()+32] Selecting from V$SQL_PLAN

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.4 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.

Symptoms

Select from V$SQL_PLAN results in ORA-07445 [msqsub()+32]

The error may happen with INSERT into STATS$SQL_PLAN as user PERFSTAT as well.

Stack trace similar to:

msqsub $cold_msqopnws msqfun k2copnws $cold_msqopnws xplUnparseOpn xplProjToText 

Cause

This was investigated in Bug 7675994 ORA-07445 [MSQSUB()+32] WHEN SELECT * FROM V$SQL_PLAN closed as duplicate of unpublished Bug 7022234.

Solution

Bug 7022234 is Fixed in 10.2.0.5 and 11.2

If a patch does not exist the following parameter can be set to workaround the problem:

alter session set "_cursor_plan_unparse_enabled"=false;

References

BUG:7675994 - ORA-07445 [MSQSUB()+32] WHEN SELECT * FROM V$SQL_PLAN