Verify Replication Caught Up
In Oracle GoldenGate Integrated capture/apply, how can we verify a large transaction has finished applying at the target?
We need to ensure a large transaction has fully applied at the target before starting the next phase of our nightly batch processing, which relies on that data being current in the target. Ideally, we'd like the validation to happen entirely in-database.
I was initially hoping I could look at the source SCN at the end of the transaction, and then look at the target's applied SCN, but I'm having a difficult time locating the SCN associated with the most recent apply action on the target side.