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} 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 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.