Use the show capture command to view statistics for the Capture process.
The basic show capture command shows an overview of the process, such as the data source, whether the process is running or stopped, and other basic information.
To view detailed statistics for the Capture process, use the show capture command with the [detail] option. That option shows detailed statistics that can help you assess the performance of the process, decide whether tuning parameters need to be adjusted, and detect problems or bottlenecks.
|Host||The name of the local machine (source system).|
|System time||The current time according to the system clock.|
|Source||The name of the source Oracle instance.|
The status of the Capture process (running or stopped).
|Operations captured||The number of operations that Capture sent to the Read process.|
|Since||The time that Capture started.|
|Oracle current redo log||The sequence number of the redo log to which Oracle is writing.|
|Capture current redo log||The sequence number of the redo log that Capture is reading.|
|Capture log offset||The location in the redo log of the record being processed by Capture.|
|Last redo record processed||The record being processed by Capture or the last one processed if Capture is not currently replicating data.|
The state of the process, in relation to the replication work it performs: It can be one of the following:
|Activation ID||The internal identifying number of the configuration activation, which identifies the associated processes and queues.|
|Error count||The number of records that were skipped due to Oracle errors since Capture started. Data from skipped records is not reflected in the target database.|
|Operations captured||The number of redo records that Capture successfully processed for replication since it started.|
|Transactions captured||The number of committed Oracle transactions whose operations Capture successfully replicated since it started.|
|Concurrent sessions||The number of Oracle sessions being processed at the same time.|
|HWM concurrent sessions||The largest number of concurrent Oracle sessions since Capture started.|
|Checkpoints performed||The number of checkpoints to save the state of Capture since Capture started. Frequent checkpointing generates additional overhead on the system, but infrequent checkpoints cause SharePlex to recover less quickly from a system or instance failure. By default, Capture checkpoints every 20,000 seconds, but it can be adjusted with the SP_OCT_CHECKPOINT_FREQ parameter.|
|Total operations processed||The number of all Oracle operations and SharePlex internal operations processed by Capture since it started, including records captured for replication and records for objects not in the configuration.|
|Total transactions completed||
The number of committed Oracle transactions processed by Capture since it started, including transactions captured for replication and transactions for objects not in the replication configuration.
|Total Kbytes read||The size in kilobytes of the data that was processed by Capture since it started.|
|Redo records in progress||The number of records that Capture is processing.|
|Redo records processed||The total number of redo records processed.|
|Redo records ignored||The number of records that Capture ignored because they are not associated with objects in the configuration.|
|Redo records - last HRID||The head row ID value for the last chained row processed by Capture.|
Note: The show capture detail output for RAC systems will vary slightly from what is described here. The information is essentially the same, but is necessarily presented differently.
|Authorization level:||Viewer (3)|
|Issued for:||source system|
|Related commands:||show export, show import, show post, show read|
|Basic command||Command options||Remote options|
[detail] [for datasource]
[ on host |
on host:portnumber |
on login/password@host |
on login/password@host:portnumber ]
Shows detailed statistics that can help you tune Capture’s performance and diagnose problems.
sp_ctrl(sysA)> show capture detail
This option shows Capture statistics only for a specific datasource.
datasource is expressed as o.SID, where SID is an ORACLE_SID.
sp_ctrl(sysA)> show capture for o.oraA
These options enable you to issue the command on a remote machine and to script commands that include a login name, password, port number, or combination of those items.
Execute the command on a remote system (one other than the one where the current sp_ctrl session is running). You are prompted for login credentials for the remote system. If used, must be the last component of the command syntax.
Example: sp_ctrl(sysB)>status on SysA
Execute the command on a remote system when a remote login and port number must be provided. If used, must be the last component of the command syntax.
Example: sp_ctrl(sysB)>status on SysA:8304
Execute the command on a remote system when a remote login, password, and host name must be provided. If used, must be the last component of the command syntax.
Example: sp_ctrl(sysB)>status on john/spot5489@SysA
Execute the command on a remote system when a remote login, password, host name, and port number must be provided. If used, must be the last component of the command syntax.
Example: sp_ctrl(sysB)>status on john/spot5489@SysA:8304