failed to collect 'streams_latency_throughput' metric and 'apply' latency shows empty
Last updated on FEBRUARY 06, 2017
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 / througput 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_FROM_CRSP11,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||'%';
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms