Checking the Failed or Pending Operations on Monitoring Template page is Hanging/Slow (Doc ID 2392797.1)

Last updated on JANUARY 10, 2023

Applies to:

Symptoms

Clicking on the Failed or Pending options in the on Monitoring template operations page is hanging the browser. The page does not recover and you need to restart the browser to check other links.

The following query is found running for 30 minutes or more in the repository database:
 
SQLID: 41f7d9v4zwhcf
 
WITH PC AS( SELECT /*+ index(dat mgmt_upd_ops_data_idx1 ) */
DAT.SOURCE_TARGET_GUID AS TEMPLATE_GUID, DET.EXECUTION_STATUS AS
EXECUTION_STATUS, DET.ERROR_MESSAGE AS ERROR_MESSAGE, DET.OPERATION_GUID AS
OPERATION_GUID, MAP.TEMPLATE_COPY_GUID AS TEMPLATE_COPY_GUID, TGT.TARGET_TYPE
AS TARGET_TYPE, OP.JOB_OWNER AS JOB_OWNER, OP.SUBMISSION_TIMESTAMP AS
SUBMISSION_TIMESTAMP, MTC.COPY_TYPE AS APPLY_OPTION, TMP.IS_MASTER_TEMPLATE
AS IS_MASTER_TEMPLATE, TCS.SYNC_TYPE AS SYNC_TYPE, MTC.DISABLE_ALERTS AS
DISABLE_ALERTS FROM MGMT_UPDATE_OPERATIONS_DATA DAT,
MGMT_UPDATE_OPERATIONS_DETAILS DET, MGMT_UPDATE_TEMPLATE_DATA_MAP MAP, ....

Cause

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