My Oracle Support Banner

EM13c: Top Activity - Historical View vs. Real Time View are not Correlated (Doc ID 2185585.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 13.1.1.0.0 and later
Information in this document applies to any platform.

Symptoms

After upgrade to 13c Cloud Control, the Top Activity of a database target does not have correlated information between the historical view and the real-time one. The Events and trends are different.

Steps to reproduce the issue:
=======

EM13c --> Click on a database target --> Performance --> Top Activity 

     -->  View data: Historical presents incorrect information.

     --> View Data: Real time show correct information and in-line with what actually goes on in the database.

Historical Data View shows Other / Queuing / Network / Administrative / Configuration wait events as the top events but AWR / ASH do not confirm any of these events. Also, regular real time activity shows no such wait events appearing on a regular basis.

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.