How can we report on long running transactions?
Answer Posted / Brijendra Kumar
To report on long running transactions in Oracle GoldenGate, you can use the ggreport command. The following is an example of how to generate a report for long running transactions:
1. Run the ggextract command with the log_archive_dest parameter set to capture transaction logs.
2. Use the ggreport command to create a report based on the captured logs, specifying the 'lag' parameter to filter out transactions that took too long to complete.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category