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

Last updated on SEPTEMBER 28, 2016

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms