EM 12c: Accessing Hosts or Databases in Enterprise Manager 12c Cloud Control Summary Page Hangs (Doc ID 2032749.1)

Last updated on MAY 20, 2016

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.4.0 to 12.1.0.5.0 [Release 12.1]
Information in this document applies to any platform.

Symptoms

From 12c EM Console, navigate: Targets > Hosts or Targets > Databases (the page hangs).

During this time, the following query causes high CPU utilization associated with the repository database:

SELECT MJ.JOB_NAME, MJ.JOB_OWNER, MJ.JOB_ID, MJ.JOB_TYPE,
MJTI.JOB_TYPE_CATEGORY, MJES.EXECUTION_ID, MJES.SCHEDULED_TIME,
MJES.START_TIME, MJES.STATUS, MT.TARGET_NAME TARGET_NAME, MT.TARGET_TYPE
TARGET_TYPE, MJES.TIMEZONE_REGION, MJES.STATUS_CODE, MJES.STATUS_BUCKET,
MGMT_JOB_SCHEDULE_RECORD( MJS.FREQUENCY_CODE, MJS.START_TIME, MJS.END_TIME,
MJS.START_GRACE_PERIOD, MJS.EXECUTION_HOURS, MJS.EXECUTION_MINUTES,
MJS.INTERVAL, MJS.MONTHS, MJS.DAYS, MJS.TIMEZONE_INFO,
MJS.TIMEZONE_TARGET_INDEX, MJS.TIMEZONE_OFFSET, MJS.TIMEZONE_REGION )
SCHEDULE FROM MGMT_JOB MJ, MGMT_JOB_EXEC_SUMMARY MJES, MGMT_JOB_EXT_TARGETS
MJET, MGMT_TARGETS MT, MGMT_JOB_TYPE_INFO MJTI, MGMT_JOB_TYPE_MAX_VERSIONS
MJTMV, MGMT_JOB_SCHEDULE MJS WHERE MJES.JOB_ID = MJ.JOB_ID AND MJES.JOB_ID =
MJET.JOB_ID AND MJ.SYSTEM_JOB = 0 AND MJ.NESTED = 0 AND
MJ.IS_CORRECTIVE_ACTION = 0 AND MJET.EXECUTION_ID = MJES.EXECUTION_ID AND
MJES.SCHEDULED_TIME > (SYSDATE - :B17 ) AND MT.TARGET_GUID = MJET.TARG
ET_GUID AND ( (:B16 = 1 ) OR (:B15 = 1 AND :B14 IS NULL AND EXISTS (SELECT 1
FROM MGMT_FLAT_TARGET_ASSOC A, MGMT_TARGETS TGT WHERE A.SOURCE_TARGET_GUID =
:B18 AND A.IS_MEMBERSHIP = 1 AND A.ASSOC_TARGET_GUID = TGT.TARGET_GUID AND
A.ASSOC_TARGET_GUID = MJET.TARGET_GUID) ) OR (:B13 IS NOT NULL AND EXISTS
(SELECT /*+ cardinality(tgts 1000) */ 1 FROM (SELECT TARGET_GUID FROM
MGMT_TARGETS WHERE TARGET_TYPE IN (SELECT * FROM TABLE( CAST(:B13 AS
SMP_EMD_STRING_ARRAY))) ) TGTS WHERE MJET.TARGET_GUID = TGTS.TARGET_GUID ) )
OR (:B13 IS NULL AND EXISTS (SELECT /*+ cardinality(tgts 100) */ 1 FROM TABLE
( CAST (:B19 AS MGMT_TARGET_GUID_ARRAY) ) TGTS WHERE MJET.TARGET_GUID =
TGTS.COLUMN_VALUE) ) ) AND MJES.STATUS_BUCKET IN (SELECT /*+ cardinality(st
10) */ * FROM TABLE(CAST(:B20 AS SMP_EMD_INTEGER_ARRAY)) ST) AND MJES.STATUS
NOT IN (:B12 , :B11 ) AND ( ( :B10 = 0 ) OR ( MJES.SCHEDULED_TIME = ( SELECT
MAX(EXEC_SUMM.SCHEDULED_TIME) FROM MGMT_JOB_EXEC_SUMMARY EXEC_SUMM WHERE
EXEC_SUMM.JOB_ID = MJES.JO B_ID AND EXEC_SUMM.STATUS_BUCKET != -1) ) ) AND
MJTMV.JOB_TYPE = MJ.JOB_TYPE AND MJTMV.MAJOR_VERSION =
MJ.JOB_TYPE_MAJOR_VERSION AND MJTI.JOB_TYPE_ID = MJTMV.JOB_TYPE_ID AND
MJS.SCHEDULE_ID = MJ.SCHEDULE_ID AND ((:B5 IS NULL) OR ( ((:B4 = :B9 ) AND
(MJ.JOB_NAME LIKE :B5 )) OR ((:B4 = :B8 ) AND (MJ.JOB_OWNER LIKE :B5 )) OR
((:B4 = :B7 ) AND (MT.TARGET_NAME LIKE :B5 )) OR ((:B4 = :B6 ) AND
(MJ.JOB_TYPE = :B5 )) OR ((:B4 = :B3 ) AND (MJTI.JOB_TYPE_CATEGORY = :B2 ))
)) AND ROWNUM

 

 

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