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.
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
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||'%';
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