To diagnose issue or tunning the performance, you can use the healthcheck script first to retrieve all the information, please refer to the follwoing support note for the latest information:
- 1448324.1 GoldenGate Integrated Capture and Integrated Replicat Healthcheck Script
For Integrated Capture:
- ALL_CAPTURE (DBA_CAPTURE)
- V$GOLDENGATE_CAPTURE (GV_$GOLDENGATE_CAPTURE)
- V$GOLDENGATE_MESSAGE_TRACKING (GV_$GOLDENGATE_MESSAGETRACKING)
- V$GOLDENGATE_TRANSACTION (GV_$GOLDENGATE_TRANSACTION)
For Integrated Replicat:
- ALL_APPLY (DBA_APPLY)
- V$GOLDENGATE_TABLE_STATS (GV_$GOLDENGATE_TABLE_STATS)
- ALL_GG_INBOUND_PROGRESS (DBA_GG_INBOUND_PROGRESS)
- ALL_GOLDENGATE_INBOUND (DBA_GOLDENGATE_INBOUND)
The following vie to check the adminstrative information:
- ALL_GOLDENGATE_PRIVILEGES (USER_GOLDENGATE_PRIVILEGES,DBA_GOLDENGATE_PRIVILEGES)
- ALL_GOLDENGATE_RULES (DBA_GOLDENGATE_RULES)
- DBA_GOLDENGATE_SUPPORT_MODE