failed to collect 'streams_latency_throughput' metric and 'apply' latency shows empty (Doc ID 976330.1)

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.

Symptoms

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 ERROR engine: [rac_database,CRSP12.GES.SYMANTEC.COM,streams_latency_throughput] : nmeegd_GetMetricData failed : Result has repeating key value : APPLY_FROM_CRSP11,apply
2009-11-18 22:42:55,223 Thread-1116 WARN collector: Error exit. Error message: Result has repeating key value : APPLY_FROM_CRSP11,apply


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


Changes

Increasing the parallelism to 4 on the apply server and the following query returns 4 rows accordingly.

SQL>SELECT PROPAGATION_NAME,MESSAGE_DELIVERY_MODE, TOTAL_NUMBER,
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
MESSAGE_DELIVERY_MODE='BUFFERED'
AND Q.DESTINATION LIKE '%'||P.DESTINATION_DBLINK||'%';

Cause

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