My Oracle Support Banner

MMON Generates Trace With ORA-00904: "PLSQL_SUBPROGRAM_ID": invalid identifier (Doc ID 463624.1)

Last updated on JULY 08, 2021

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.