Commands Used for Monitoring

You can view information about Extract and Replicat groups from the Oracle GoldenGate MA web interface at various levels. Another alternative is to use the command line interface to monitor various processes.

See Monitor Processes from the Performance Metrics Service.

To learn about command syntax, usage, and examples, see the Command Line Interface Reference for Oracle GoldenGate.

Command	What it Shows
INFO {EXTRACT | REPLICAT} group [DETAIL]	Run status, checkpoints, approximate lag, and environmental information.
INFO ALL	Displays the INFO output for all Oracle GoldenGate processes on the system.
STATS {EXTRACT | REPLICAT} group	Displays statistics on processing volume, such as number of operations performed.
STATUS {EXTRACT | REPLICAT} group	Displays the run status (starting, running, stopped, abended) for Extract and Replicat processes.
LAG {EXTRACT | REPLICAT} group	Displays the latency between last record processed and timestamp in the data source.
INFO {EXTTRAIL | RMTTRAIL } trail	Displays the name of associated process, position of last data processed, maximum file size.
SEND {EXTRACT | REPLICAT } group	Depending on the process and selected options, returns information about memory pool, lag, TCP statistics, long-running transactions, process status, recovery progress, and more.
VIEW REPORT group	Shows contents of the discard file or process report.
VIEW GGSEVT	Shows contents of the Oracle GoldenGate error log.
COMMAND ER wildcard	Information dependent on the COMMAND type: INFO LAG SEND STATS STATUS wildcard is a wildcard specification for the process groups to be affected, for example: INFO ER ext* STATS ER *
INFO PARAM	Queries for and displays static information.
GETPARAMINFO	Displays currently-running parameter values.
INFO DISTPATH	Returns information about distribution paths. Before you run this command, ensure that the Distribution Service is running for that deployment.
INFO EXTTRAIL	Retrieves configuration information for a local trail. It shows the name of the trail, the Extract that writes to it, the position of the last data processed, and the assigned maximum file size.
INFO RMTTRAIL	Retrieves configuration information for a remote trail. It shows the name of the trail, the Extract that writes to it, the position of the last data processed, and the assigned maximum file size.
INFO ER	Retrieves information on multiple Extract and Replicat groups as a unit.
INFO CHECKPOINTTABLE	Confirms the existence of a checkpoint table and view the date and time that it was created.
INFO CREDENTIALS	Retrieves a list of credentials.
INFO ENCRYPTIONPROFILE	Returns information about the encryption profiles available with the Service Manager.
INFO HEARTBEATTABLE	Displays information about the heartbeat tables configured in the database.
INFO AUTHORIZATIONPROFILE	Lists all the authorization profiles in a deployment or information on a specific authorization profile for a specific deployment.
INFO MASTERKEY	Displays the contents of a currently open master-key wallet. If a wallet store does not exist, a new wallet store file is created. This wallet store file is then used to host different encrypted keys as they are created.
INFO PROFILE	Returns information about managed process profiles.
INFO RECVPATH	Returns information about a target-initiated distribution path in the Receiver Service. Before you run this command, ensure that the Receiver Service is running.
INFO SCHEMATRANDATA	Valid for Oracle database only. Determine whether Oracle schema-level supplemental logging is enabled for the specified schema or if any instantiation information is available. Use the DBLOGIN command to establish a database connection before using this command.
INFO TRACETABLE	Verifies the existence of the specified trace table in the local instance of the database.
INFO TRANDATA	Displays different outputs depending on the database.
STATS DISTPATH | RECVPATH	Get the statistics for the distribution path (DISTPATH) or receiver path (RECVPATH).
STATS ER	Retrieve statistics on multiple Extract and Replicat groups as a unit. Use it with wildcards to affect every Extract and Replicat group that satisfies the wildcard.
STATUS ER	Checks the status of multiple Extract and Replicat groups as a unit.
STATUS DEPLOYMENT	View the status of the specified deployment.
STATUS PMSRVR	Status of Performance Service.
STATUS SERVICE	Displays the status of specified Oracle GoldenGate service.