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. |
|
Displays the |
|
Displays statistics on processing volume, such as number of operations performed. |
|
Displays the run status (starting, running, stopped, abended) for Extract and Replicat processes. |
|
Displays the latency between last record processed and timestamp in the data source. |
|
Displays the name of associated process, position of last data processed, maximum file size. |
|
Depending on the process and selected options, returns information about memory pool, lag, TCP statistics, long-running transactions, process status, recovery progress, and more. |
|
Shows contents of the discard file or process report. |
|
Shows contents of the Oracle GoldenGate error log. |
|
Information dependent on the
is a wildcard specification for the
process groups to be affected, for
example:
|
|
Queries for and displays static information. |
|
Displays currently-running parameter values. |
|
Returns information about distribution paths. Before you run this command, ensure that the Distribution Service is running for that deployment. |
|
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. |
|
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. |
|
Retrieves information on multiple Extract and Replicat groups as a unit. |
|
Confirms the existence of a checkpoint table and view the date and time that it was created. |
|
Retrieves a list of credentials. |
|
Returns information about the encryption profiles available with the Service Manager. |
|
Displays information about the heartbeat tables configured in the database. |
|
Lists all the authorization profiles in a deployment or information on a specific authorization profile for a specific deployment. |
|
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. |
|
Returns information about managed process profiles. |
|
Returns information about a target-initiated distribution path in the Receiver Service. Before you run this command, ensure that the Receiver Service is running. |
|
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 |
|
Verifies the existence of the specified trace table in the local instance of the database. |
|
Displays different outputs depending on the database. |
|
Get the statistics for the distribution path (DISTPATH) or receiver path (RECVPATH). |
|
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. |
|
Checks the status of multiple Extract and Replicat groups as a unit. |
|
View the status of the specified deployment. |
|
Status of Performance Service. |
|
Displays the status of specified Oracle GoldenGate service. |