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 220.127.116.11.0 and later
Information in this document applies to any platform.
E-Business Suite 18.104.22.168
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.
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