So far we've talked mostly about configurations and very little about managing an OGG instance. We'll discuss some of the more common management commands you'll probably use most often.
Here you'll get to know some of the most useful commands for displaying OGG status and/or for root cause analysis investigation.
GGSCI> info ex01sand showch
The output of the preceding command will be as follows:
… Recovery Checkpoint (position of oldest unprocessed transaction in the data source): Thread #: ...