EM 12c: APPLSYS.aq$WF_CONTROL query in Enterprise Manager 12c Cloud Control with AMP Runs Every 15 Minutes (Doc ID 1593352.1)

Last updated on APRIL 03, 2015

Applies to:

Enterprise Manager for Fusion Applications - Version 12.1.0.1.0 and later
Information in this document applies to any platform.
E-Business Suite 11.5.10.2

Symptoms

The 12c Enterprise Manager Cloud Control Oracle Management Services (OMS) runs a query running every 15 minute:

select msg_state, count(*)
from APPLSYS.aq$WF_CONTROL
where (queue = :q or queue = :r) group by msg_state


This query is run from the Cloud Control 12c Management Agent using the AMP 4.0 add-on. (Applications Management Pack). The plugin shown on the OMS console is emagent_sql_oracle_ebs.

The parsing user is apps, but the query is originating from the agent as part of the Applications monitoring arrangement.

Module emagent_SQL_oracle_ebs
Action Agent Activity
Parsing Schema APPS
PL/SQL Source (Line Number) APPS.WF_QUEUE (3029)
SQL Profile n/a
SQL Plan Baseline n/a


The row count is very large and from the OMS console graph it consumes 61.1% CPU.



Changes

 Recently applied the AMP (Application Management Pack) 4.0 to Oracle Cloud Control 12c.

 

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