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.
Symptoms
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 ERROR engine: [rac_database,<DB.Domain_Name>,streams_latency_throughput] : nmeegd_GetMetricData failed : Result has repeating key value : <APPLY_NAME>,apply
2009-11-18 22:42:55,223 Thread-1116 WARN collector: Error exit. Error message: Result has repeating key value : <APPLY_NAME>,apply
2009-11-18 22:42:55,223 Thread-1116 WARN collector: Error exit. Error message: Result has repeating key value : <APPLY_NAME>,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
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 |
| Changes |
| Cause |
| Solution |
| References |