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