GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

OGG: Find the number of records per transaction using logdump?

edited Aug 19, 2017 5:04AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered

I was curious if there was a more direct way to determine how many records there are for a particular transaction while using logdump.  I have found that if I use FILTER TRANSIND 0 to show only the records at the start of a transaction and then use the NEXT command it will tell me how many records were suppressed before it got to the next transaction, but wasn't sure if I was overlooking a simpler command.

I did also use the TRANSHIST command coupled with count and it would have the record count in there if there were transactions that meet a certain criteria.  I think the default is that it flags transactions that have more than 100 records or the transaction itself is larger than 1MB, honestly unsure how the TRANSHIST command is supposed to work because I get the same results whether I use TRANSHIST 1 or TRANSHIST 100.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center