监控Goldengate状态(二)
Total inserts 86592.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 86592.00
*** Hourly statistics since 2015-03-03 21:24:31 ***
Total inserts 86592.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 86592.00
*** Latest statistics since 2015-03-03 21:24:31 ***
Total inserts 86592.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 86592.00
End of Statistics.
GGSCI (zbdba1) 42> stats extract ext1 reportrate hr
Sending STATS request to EXTRACT EXT1 ...
Start of Statistics at 2015-03-03 21:43:05.
DDL replication statistics (for all trails):
*** Total statistics since extract started ***
Operations 1.00
Mapped operations 1.00
Unmapped operations 0.00
Other operations 0.00
Excluded operations 0.00
Output to ./dirdat/sa:
Extracting from OGG.GGS_MARKER to OGG.GGS_MARKER:
*** Total statistics since 2015-03-03 21:24:31 ***
No database operations have been performed.
*** Daily statistics since 2015-03-03 21:24:31 ***
No database operations have been performed.
*** Hourly statistics since 2015-03-03 21:24:31 ***
No database operations have been performed.
*** Latest statistics since 2015-03-03 21:24:31 ***
No database operations have been performed.
Extracting from ZBDBA.TEST to ZBDBA.TEST:
*** Total statistics since 2015-03-03 21:24:31 ***
Total inserts/hour: 280006.18
Total updates/hour: 0.00
Total deletes/hour: 0.00
Total discards/hour: 0.00
Total operations/hour: 280006.18
*** Daily statistics since 2015-03-03 21:24:31 ***
Total inserts/hour: 280006.18
Total updates/hour: 0.00
Total deletes/hour: 0.00
Total discards/hour: 0.00
Total operations/hour: 280006.18
*** Hourly statistics since 2015-03-03 21:24:31 ***
Total inserts/hour: 280006.18
Total updates/hour: 0.00
Total deletes/hour: 0.00
Total discards/hour: 0.00
Total operations/hour: 280006.18
*** Latest statistics since 2015-03-03 21:24:31 ***
Total inserts/hour: 280006.18
Total updates/hour: 0.00
Total deletes/hour: 0.00
Total discards/hour: 0.00
Total operations/hour: 280006.18
Extracting from ZBDBA.TEST3 to ZBDBA.TEST3:
*** Total statistics since 2015-03-03 21:24:31 ***
Total inserts/hour: 280015.88
Total updates/hour: 0.00
Total deletes/hour: 0.00
Total discards/hour: 0.00
Total operations/hour: 280015.88
*** Daily statistics since 2015-03-03 21:24:31 ***
Total inserts/hour: 280015.88
Total updates/hour: 0.00
Total deletes/hour: 0.00
Total discards/hour: 0.00
Total operations/hour: 280015.88
*** Hourly statistics since 2015-03-03 21:24:31 ***
Total inserts/hour: 280015.88
Total updates/hour: 0.00
Total deletes/hour: 0.00
Total discards/hour: 0.00
Total operations/hour: 280015.88
*** Latest statistics since 2015-03-03 21:24:31 ***
Total inserts/hour: 280015.88
Total updates/hour: 0.00
Total deletes/hour: 0.00
Total discards/hour: 0.00
Total operations/hour: 280015.88
End of Statistics.
GGSCI (zbdba1) 44>
send extract ext1,getlag
Sending GETLAG request to EXTRACT EXT1 ...
Last record lag: 2 seconds.
At EOF, no more records to process.
GGSCI (zbdba1) 45> lag extract ext*
Sending GETLAG request to EXTRACT EXT1 ...
Last record lag: 2 seconds.
At EOF, no more records to process.
Sending GETLAG request to EXTRACT EXT2 ...
Last record lag: 10 seconds.
At EOF, no more records to process.
GGSCI (zbdba1) 46> vi