We are using Striim to replicate data from Oracle to BigQuery
I would like to know how can I find out for UI
Thank You
Best answer by john
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 │
└──────────────────────────────────────┴─────────────────────────────────────────────────────────────────────────────────────────────────┘
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 │
└──────────────────────────────────────┴─────────────────────────────────────────────────────────────────────────────────────────────────┘
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.