My Oracle Support Banner

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 later
Information 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


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