search

averemee-si / oracdc

Oracle database CDC (Change Data Capture)
http://a2-solutions.eu/
Apache License 2.0
105 stars 36 forks source link

JMX metric for lag #18

Closed sonnguyen-dba closed 3 years ago

sonnguyen-dba commented 3 years ago

Hi Aleksei, JMX metric for lag when performing log switch in oracdc!

[2021-05-01 21:57:14,973] INFO WorkerSourceTask{id=oracdc-oracle-ov-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:443) [2021-05-01 21:57:24,054] INFO Adding archived log /archivelog/2021_05_01/o1_mf_1_178719j8ttv7n8.arc thread# 1 sequence# 178719 first change number 729454531557 next log first change 729458464137 (eu.solutions.a2.cdc.oracle.OraCdcV$ArchivedLogImpl:146) [2021-05-01 21:57:24,973] INFO WorkerSourceTask{id=oracdc-oracle-ov-0} Committing offsets (org.apache.kafka.connect.runtime.WorkerSourceTask:426) [2021-05-01 21:57:24,974] INFO WorkerSourceTask{id=oracdc-oracle-ov-0} flushing 0 outstanding messages for offset commit (org.apache.kafka.connect.runtime.WorkerSourceTask:443)

-rw-r----- 1 oracle oinstall May 1 21:13 o1_mf_1_178717j8trjjhg.arc -rw-r----- 1 oracle oinstall May 1 21:30 o1_mf_1_178718j8tsj0ow.arc -rw-r----- 1 oracle oinstall May 1 21:53 o1_mf_1_178719j8ttv7n8.arc

Screen Shot 2021-05-01 at 22 04 26

Regards, Son

averemee-si commented 3 years ago

Hi Son,

Could you please try latest code from GitHub which includes commit JMX metric for actual lag - this code adds two additional metrics to JMX - ActualLagSeconds and ActualLagText

Regards, Aleksei

sonnguyen-dba commented 3 years ago

Thanks Aleksei, Regards, Son