Golden Gate Plugin Dashboard Takes Very Long Time To Load (Doc ID 2897133.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Golden Gate Plugin Dashboard taking very long time to load.

While the dashboard is loading, we could see below SQL running in the database with several execution and each execution taking approx 10 to 11 sec. Here is a sample from an AWR report while trying to access the OEM GoldenGate Target page.

2zp3a7x7whh1n

SELECT * FROM (SELECT COLLECTION_TIMESTAMP,TARGET_NAME,VALUE,ROW_NUMBER()
OVER ( PARTITION BY TARGET_NAME ORDER BY COLLECTION_TIMESTAMP) RANK FROM
mgmt$metric_details WHERE target_type IN
('oracle_goldengate_extract','oracle_goldengate_replicat','oracle_goldengate_m
anager') AND metric_name IN
('ExtractMetric','ReplicatMetric','ManagerMetric','ReplicatParallelMetric')
and metric_column in ('em_lag','em_lag'))WHERE RANK < :1

Cause

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