EM 12c: APPLSYS.aq$WF_CONTROL query in Enterprise Manager 12c Cloud Control with AMP Runs Every 15 Minutes
Last updated on APRIL 03, 2015
Applies to:Enterprise Manager for Fusion Applications - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
E-Business Suite 22.214.171.124
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.
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