Solved

Oracle CDC

  • 26 July 2022
  • 2 replies
  • 113 views

We are using Striim to replicate data from Oracle to BigQuery

I would like to know how can I find out for UI

  1. current archived logs being mined by log miner
  2. The current DDL ( LCR , logical count record ) being processed) 
  3. Number of DDLs or LCR in the current Transaction or SCN

Thank You

icon

Best answer by john 28 July 2022, 18:27

View original

2 replies

Userlevel 1
Badge

 In the UI, go to the Console by clicking ‘Console’ in the top nav.

 

Enter the command “mon <namespace>.<component name> [ <node> ]” for your OracleReader. 

For an OracleReader source, output will include the following:

╒════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════════╕
│ SOURCE ns1.ora2striim_OracleSource │
├──────────────────────────────────────┬─────────────────────────────────────────────────────────────────────────────────────────────────┤
│ Property │ Value │
├──────────────────────────────────────┼─────────────────────────────────────────────────────────────────────────────────────────────────┤
│ Catalog evolution duration │ Not Ready │
│ Schema Evolution Status │ NotApplicable │
│ CDC Operation │ { │
│ │ "No of Deletes" : 0, │
│ │ "No of DDLs" : 0, │
│ │ "No of PKUpdates" : 0, │
│ │ "No of Updates" : 0, │
│ │ "No of Inserts" : 10 │
│ │ } │
│ CPU │ 0.00029 │
│ CPU Rate Per Node │ 0.007% │
│ CPU Rate │ 0.029% │
│ Number of events seen per monitor │ 0 │
│ snapshot interval │ │
│ Input │ 10 │
│ Input Rate │ 0 │
│ Largest transaction details │ TxnID : 8.25.946 Operation count : 12 │
│ Last Event Position │ 01eba881-2a1b-93b1-8a82-8cae4cf129d6/*@[{OpenSCN[2466241]-CommitSCN[2467119]-SeqNum[10]} | %] │
│ Latest Activity │ 2021-04-29 12:06:09 │
│ Logminer Start Duration │ 4ms │
│ Oldest Open Transactions │ [{"3.15.924":{"# of Ops":11,"CommitSCN":"null","Sequence #":"1","StartSCN":"2467200","Rba │
│ │ block #":"11","Thread #":"1","TimeStamp":"2021-04-29T19:06:16.000-07:00"}}] │
│ Longest transaction details │ TxnID : 8.25.946 Open Duration : 114 seconds │
│ Open transactions in cache │ 1 │
│ Uninterested transactions in cache │ 0 │
│ Nodes │ 1 │
│ Oracle Reader Current SCN │ 2467327 │
│ Current SCN Range │ 2467254-2467327 │
│ Oracle Reader Last SCN │ 2467254 │
│ Oracle Reader Last Timestamp │ 2021-04-29 12:06:35 │
│ Total Logminer Records read │ 1209 │
│ Redo Switch Count │ 0 │
│ Rate │ 0 │
│ Read Lag │ -25,083,374 │
│ Source Input │ 10 │
│ Source Rate │ 0 │
│ StartSCN │ 2466068 │
│ Table Information │ { │
│ │ "HR.JOB_HISTORY" : { │
│ │ "No of Deletes" : 0, │
│ │ "No of DDLs" : 0, │
│ │ "No of PKUpdates" : 0, │
│ │ "No of Updates" : 0, │
│ │ "No of Inserts" : 10 │
│ │ } │
│ │ } │
│ Timestamp │ 2021-04-29 12:07:14 │
│ Top Open Transactions (# of Ops) │ [{"3.15.924":{"# of Ops":11,"CommitSCN":"null","Sequence #":"1","StartSCN":"2467200","Rba │
│ │ block #":"11","Thread #":"1","TimeStamp":"2021-04-29T19:06:16.000-07:00"}}] │
│ Operations in the Cache │ 11 │
│ Total number of Reconnects │ 0 │
└──────────────────────────────────────┴─────────────────────────────────────────────────────────────────────────────────────────────────┘

 

Found it, we need to enable LINGAGE

Reply