标题: MMON trace file grows and is flooded with: kmgs_parameter_update_timeout Gen0... [打印本页] 作者: 郑全 时间: 2018-6-27 18:52 标题: MMON trace file grows and is flooded with: kmgs_parameter_update_timeout Gen0... MMON trace file grows and is flooded with: kmgs_parameter_update_timeout Gen0 messages (文档 ID 2319931.1)
In this Document
Symptoms
Changes
Cause
Solution
References
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Information in this document applies to any platform.
Symptoms
MMON trace file grows abnormally and the following messages may be noticed repeatedly within the trace:
2017-08-16 16:38:20.688 : [ CSSCLNT][ CSSCLNT]clsssinit: initialized context: (0x7f2d342f9138) flags 0x915
AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1
AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1
dbkrfssm: mmon not open
dbkrfssm: mmon not open
*** 2017-08-16T16:38:23.916367+02:00 (CDB$ROOT(1))
AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1
*** 2017-08-16T16:38:26.916399+02:00 (CDB$ROOT(1))
AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1
*** 2017-08-16T16:38:27.670423+02:00 (CDB$ROOT(1))
AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1
AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1
Changes
Upgrade to 12.2.0.1
Cause
This issue is caused by
Unpublished Bug 25415713 - MMON TRACE FILE GROWS WHEN NO TRACES ARE ENABLED
Solution
Apply patch for Bug 25415713 for Unix/Linux platform.
For Windows platform, patch 25415713 doesn't work, patch 27248708 should be applied. Patch 27248708 is included in WINDBBP 12.2.0.1.180531.
References
BUG:27248708 - AUTO SGA: KMGS_PARAMETER_UPDATE_TIMEOUT AFTER INSTALL 25415713 IN WINDOWS