Golden Gate Plugin Dashboard Takes Very Long Time To Load
(Doc ID 2897133.1)
Last updated on JULY 20, 2024
Applies to:
Management Pack for Oracle GoldenGate - Version 12.2.1.2.0 and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |