High Number Of J00 And M00 Trace Files Since Upgrade To Oracle 19.7

郑全

High Number Of J00 And M00 Trace Files Since Upgrade To Oracle 19.7 . (Doc ID 2731121.1)

In this Document
Symptoms
Changes
Cause
Solution

APPLIES TO:
Oracle Database - Enterprise Edition - Version 19.6.0.0.0 to 19.7.0.0.0 [Release 19]
Information in this document applies to any platform.
SYMPTOMS
The database was upgraded to 19.7 and started to generate High number of j00 and m00 trace files.

Example of M00 trace:

*** 2020-09-14T16:15:16.328779+02:00
*** MODULE NAME:(MMON_SECONDARY) 2020-09-14T16:15:16.328820+02:00
*** ACTION NAME:(KDILM background CLeaNup) 2020-09-14T16:15:16.328831+02:00

*********** START A RUN OF [KDILM background CLeaNup] *************
*********** END A RUN *************
*** MODULE NAME:(MMON_SECONDARY) 2020-09-14T16:15:16.328971+02:00
*** ACTION NAME:(Auto-Flush Secondary Action) 2020-09-14T16:15:16.328982+02:00

*********** START A RUN OF [Auto-Flush Secondary Action] *************
*********** END A RUN *************
*** MODULE NAME:(MMON_SECONDARY) 2020-09-14T16:15:16.331220+02:00
*** ACTION NAME:(Intensive AutoTask Dispatcher) 2020-09-14T16:15:16.331233+02:00

*********** START A RUN OF [Intensive AutoTask Dispatcher] *************
*********** END A RUN *************

*** 2020-09-14T16:16:16.377028+02:00
*** MODULE NAME:(MMON_SECONDARY) 2020-09-14T16:16:16.377075+02:00
*** ACTION NAME:(KDILM background EXEcution) 2020-09-14T16:16:16.377086+02:00

*********** START A RUN OF [KDILM background EXEcution] *************
*********** END A RUN *************
*** MODULE NAME:(MMON_SECONDARY) 2020-09-14T16:16:16.377224+02:00
*** ACTION NAME:(KDILM background CLeaNup) 2020-09-14T16:16:16.377236+02:00

*********** START A RUN OF [KDILM background CLeaNup] *************
*********** END A RUN *************
*** MODULE NAME:(MMON_SECONDARY) 2020-09-14T16:16:16.377334+02:00
*** ACTION NAME:(Intensive AutoTask Dispatcher) 2020-09-14T16:16:16.377344+02:00

*********** START A RUN OF [Intensive AutoTask Dispatcher] *************
*********** END A RUN *************

*** 2020-09-14T16:17:16.383243+02:00
*** MODULE NAME:(MMON_SECONDARY) 2020-09-14T16:17:16.383289+02:00
*** ACTION NAME:(KDILM background CLeaNup) 2020-09-14T16:17:16.383300+02:00

*********** START A RUN OF [KDILM background CLeaNup] *************
*********** END A RUN *************
*** MODULE NAME:(MMON_SECONDARY) 2020-09-14T16:17:16.383449+02:00
*** ACTION NAME:(Intensive AutoTask Dispatcher) 2020-09-14T16:17:16.383461+02:0


CHANGES
upgraded to 19.7

CAUSE
Known bug.

Bug 31751034 HAVING EXCESSIVE M0* TRACING AFTER FIX FOR 30972959 HAS BEEN APPLIED
Bug 30329751 - ASM INSTANCE MMON_SLAVE M000 TRC KEEPS GENERATING MESSAGE CLEANUP KGL HANDLE ACTION
Bug 30972959 - EXCESSIVE TRACING - M* SLAVE TRACES FILLED ACTION RUN INFORMATION


SOLUTION
Apply Patch 31930222: MERGE ON DATABASE RU 19.7.0.0.0 OF 30329751 30972959