MMON Generates Trace With ORA-00904: "PLSQL_SUBPROGRAM_ID": invalid identifier
(Doc ID 463624.1)
Last updated on JANUARY 08, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [Release 10.2]Information in this document applies to any platform.
This problem can occur on any platform.
Symptoms
MMON generates traces containing the following entries:
*** ACTION NAME:(Auto-Flush Secondary Action) 2007-10-19 09:00:38.439
*** MODULE NAME:(MMON_SECONDARY) 2007-10-19 09:00:38.439
*** SERVICE NAME:(SYS$BACKGROUND) 2007-10-19 09:00:38.439
*** SESSION ID:(325.3652) 2007-10-19 09:00:38.439
*** KEWROCISTMTEXEC - encountered error: (ORA-00904: "PLSQL_SUBPROGRAM_ID": invalid identifier
)
*** SQLSTR: total-len=1699, dump-len=240,
STR={INSERT /*+ APPEND */ INTO WRH$_ACTIVE_SESSION_HISTORY ( snap_id, dbid, instance_number, sample_id, sample_time, session_id, session_serial#, user_id, sql_id, sql_child_number, sql_plan_hash_value, force_matching_signature, service_}
kewa_flusher: Exception handler 13509 - Will resignal!
*** KEWRAFM1: Error=13509 encountered by kewrfteh
Changes
Recent upgrade occurred.
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 |