My Oracle Support Banner

EM 12c: Redo Logging is Drastically Increased in the Enterprise Manager 12c Cloud Control Repository Database after Upgrade to 12.1.0.2 (PS1) and EM_JOB_METRICS Table is Very Large in Size (Doc ID 1502370.1)

Last updated on FEBRUARY 17, 2019

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms

After performing an upgrade to Enterprise Manager (EM) 12.1.0.2.0 Cloud Control, the database hosting the EM 12c repository experiences significantly increased redo logging.
Executing LogMiner against the database for about 20 minutes shows 200MB+ logs worth of repository database operation.  The SYSMAN user is performing frequent inserts on EM_JOB_METRICS (about 60 inserts per second).

 The EM_JOB_METRICS table does not exist in a 12.1.0.1.1 (12c EM with Bundle patch 1) installation. 

Changes

Recently upgrade to the 12.1.0.2 version.

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
References


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