12c EM Rollup Job Runs for Long time and Goes into Invalid Status (Doc ID 2032322.1)

Last updated on JULY 15, 2015

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.4.0 and later
Information in this document applies to any platform.

Symptoms

12c EM

             SELECT V.METRIC_ITEM_ID METRIC_ITEM_ID, TRUNC(V.COLLECTION_TIME, 'DD') COLLECTION_DAY, TRUNC(V.COLLECTION_TIME, 'HH') COLLECTION_HOUR, G.NUM_NUMERIC_COLS NUM_NUMERIC_COLS, V.MET_VALUES MET_VALUES FROM    EM_METRIC_VALUES V, EM_METRIC_ITEMS I, EM_ROLLUP_TARGET_LIST_TMP T, EM_METRIC_GROUPS G WHERE V.METRIC_ITEM_ID = I.METRIC_ITEM_ID AND I.TARGET_GUID = T.TARGET_GUID AND I.METRIC_GROUP_ID = G.METRIC_GROUP_ID AND V.COLLECTION_TIME >= T.ROLLUP_TIMESTAMP AND V.COLLECTION_TIME < T.CURR_ROLLUP_TIME AND V.COLLECTION_TIME >= :B5 AND V.COLLECTION_TIME < :B4 AND T.ROLLUP_TABLE_NAME = 'EM_METRIC_VALUES_DAILY' AND T.INST_ID = :B3 AND T.WORKER_ID = :B2 AND T.BATCH_ID = :B1 AND T.STATUS = 'R' ORDER BY METRIC_ITEM_ID, COLLECTION_HOUR

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