My Oracle Support Banner

EM13c : Excessive Performance Logging Observed In ECM Modules Tables (Doc ID 2643582.1)

Last updated on FEBRUARY 28, 2020

Applies to:

Enterprise Manager Base Platform - Version 13.2.0.0.0 to 13.4.0.0.0 [Release 13c]
Information in this document applies to any platform.

Symptoms

In Enterprise Manager (EM) Cloud Control, Due to the ECM Modules, there is an excessive logging observed in the performance tables which can lead to performance issues.

SQL> SELECT Count(1) FROM mgmt_system_performance_log WHERE job_name='EM.ECM';

COUNT(1)
----------
12150316

SQL> SELECT MODULE, Count(1) FROM mgmt_system_performance_log WHERE job_name='EM.ECM' GROUP BY MODULE ORDER BY 2;

MODULE                                                              COUNT(1)
-------------------------------------------------- ----------
AFTER_LOAD_CALLBACK                            48881
Configuration Comparison preprocessing   285402
COMPUTE HISTORY                                287406
UPDATE_TARGET_COMPONENTS                 307681
DERIVED ASSOCS                                   307681
RUN_SNAPSHOT_DEPENDENT_COLLS          307681
Patch Recommendation                          322170
INFORM COMPLIANCE                             322170
POSTLOAD_CALLBACK                                 4977782
PRELOAD_CALLBACK                                    4990369

There should not be too much of logging done by the ECM modules in the performance tables.

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
Cause
Solution
References


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