Using the Information Commands

You can view information about Oracle GoldenGate processes from the Oracle GoldenGate MA web interface or use the command line interface to monitor various processes.

See Monitoring Performance, Monitoring Trails, , Monitoring Distribution Path Information Statistics in the Step by Step Data Replication Using Oracle GoldenGate Microservices guide.

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

Table 9-1 Commands to View Process Information

Command	What it shows
`INFO {EXTRACT \| REPLICAT}` `group` `[DETAIL]`	Run status, checkpoints, approximate lag, and environmental information.
`INFO MANAGER`	Run status and port number
`INFO ALL`	`INFO` output for all Oracle GoldenGate processes on the system
`STATS {EXTRACT \| REPLICAT}` `group`	Statistics on processing volume, such as number of operations performed.
`STATUS {EXTRACT \| REPLICAT}` `group`	Run status (starting, running, stopped, abended)
`STATUS MANAGER`	Run status
`LAG {EXTRACT \| REPLICAT}` `group`	Latency between last record processed and timestamp in the data source
`INFO {EXTTRAIL` `\|` `RMTTRAIL}` `trail`	Name of associated process, position of last data processed, maximum file size
`SEND MANAGER`	Run status, information about child processes, port information, trail purge settings
`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`	Contents of the discard file or process report
`VIEW GGSEVT`	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 SERVICE`	Displays the status of specified Oracle GoldenGate services.