My Oracle Support Banner

EM 12c:$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 and later
Information in this document applies to any platform.
E-Business Suite


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

select msg_state, count(*)
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.


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



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

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