failed to collect 'streams_latency_throughput' metric and 'apply' latency shows empty
(Doc ID 976330.1)
Last updated on FEBRUARY 22, 2019
Applies to:Enterprise Manager for Oracle Database - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]
Information in this document applies to any platform.
In cluster -> Cluster Database: xxx -> streams -> Overview page the 'propagation latency' chart is empty.
It says "no data is currently available"
Apply latency / throughput metrics is not showing on GC console and emagent.trc shows the following collection errors:
2009-11-18 22:42:55,223 Thread-1116 WARN collector: Error exit. Error message: Result has repeating key value : <APPLY_NAME>,apply
Agent Version : 10.2.0.5.0
OMS Version : 10.2.0.5.0
RAC DB version: 10.2.0.4 on AIX 5.3
Increasing the parallelism to 4 on the apply server and the following query returns 4 rows accordingly.
TOTAL_BYTES/1024 KBYTES FROM DBA_PROPAGATION P, DBA_QUEUE_SCHEDULES Q WHERE
P.SOURCE_QUEUE_NAME = Q.QNAME AND P.SOURCE_QUEUE_OWNER = Q.SCHEMA AND
AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%';
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