show
Show command
Use the show command to view the replication processes for an instance of sp_cop and the path the data is taking.
The following describes each column in the show command display:
Process
The Process column shows the SharePlex replication processes (services) spawned by the instance of sp_cop to which the current sp_ctrl session is connected. The command does not show the command and control process (sp_cnc) or any compare processes that are running.
- If there are named export queues, there are multiple Export or Import processes, depending on whether it is a source or target sp_cop.
- If there are named post queues, there are multiple Post processes, one for each queue.
- The Post process is labeled MTPost.
- For an instance of sp_cop running peer-to-peer replication, or for those that serve as both source and target sp_cop instances, all SharePlex replication processes are present.
Source
The Source column shows the source of the data being processed by a SharePlex process. A source can be one of the following:
- For a Capture or Read process: the datasource (the source Oracle instance).
- For an Export process: the name of the associated export queue. Default export queues bear the name of the source system. Named export queues bear their userassigned names, for example exptq1.
- For an Import process: the name of the associated default export queue (for example, sysA), or the name of the associated named export queue, such as exptq1.
- For a Post process: There can be one of several displays for the source of a Post process, depending on the replication configuration:
- When there is a default export queue and a default post queue, the Post source is the short name of the associated post queue. The short name consists of the datasource and the source system’s name, in the format of o.ora10-elliot.
- When there is a named export queue (which automatically creates a named post queue on the target system) the Post source consists of the datasource and the named export queue’s name, in the format of o.ora10-exptq1.
- When there is a default export queue and a named post queue, the Post source consists of the datasource and the named post queue’s name, for example o.ora10- postq1.
Target
The Target column shows the destination, or target, of the data being processed by a SharePlex process.
A target can be one of the following:
- For a Capture or Read process: There is no target to show for these processes. The data captured by the Capture process and routed by the Read process can be routed to one or many destinations.
- For an Export process: the name of the target system.
- For an Import process: the name of the target system.
- For a Post process: the target.
State
The State column shows the status of each process:
- Running
- Idle (waiting for data to process)
- Stopped by a user
- Stopped because of an error.
PID
This column lists the process ID number for each process.
Usage
| Supported sources: |
Oracle |
| Supported targets: |
All |
| Authorization level: |
Viewer (3) |
| Issued for: |
source or target system |
| Related commands: |
lstatus, qstatus, status |
Syntax
| show |
[ on host |
on host:portnumber |
on login/password@host |
on login/password@host:portnumber ] |
Remote options
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.
| on host |
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 |
| on host:portnumber |
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 |
| on login/password@host |
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 |
| on login/password@host:portnumber |
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 |
show capture
Use of Show Capture
Use the show capture command to view statistics for the Capture process.
Basic command
The basic show capture command shows an overview of the process, such as the datasource, whether the process is running or stopped, and other basic information.
Detailed statistics
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.
Detailed statistics for Oracle Capture
| 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. |
| Status |
The status of the Capture process (running or stopped). |
| 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. |
| Capture state |
The state of the process, in relation to the replication work it performs
It can be one of the following:
- INITIALIZING: Capture is starting up.
- WAITING: Capture is reading the redo log and waiting for records that need to be replicated.
- WAITING FOR LOGFILE: Capture is configured to wait and then try again if it cannot access the required log.
- PROCESSING: Capture is processing a redo log record for replication.
- STOPPED DUE TO MISSING ARCHIVE LOG: Capture is configured to stop when it cannot access the log that it needs.
|
| 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 2,000 messages, 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.
Usage
| Supported sources: |
Oracle |
| Supported targets: |
All |
| Authorization level: |
Viewer (3) |
| Issued for: |
source system |
| Related commands: |
show export, show import, show post, show read |
Syntax
| show capture |
[detail] [for datasource] |
[ on host |
on host:portnumber |
on login/password@host |
on login/password@host:portnumber ] |
Syntax description
| show capture |
Shows the state of the Capture process and a summary of the operations captured. |
| detail |
Shows detailed statistics that can help you tune Capture’s performance and diagnose problems.
Example:
sp_ctrl(sysA)> show capture detail |
| for datasource |
This option shows Capture statistics only for a specific datasource.
datasource is expressed as o.SID where SID is an ORACLE_SID.
Examples:
sp_ctrl(sysA)> show capture for o.oraA |
Remote options
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.
| on host |
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 |
| on host:portnumber |
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 |
| on login/password@host |
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 |
| on login/password@host:portnumber |
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 |
show config
Use the show config command to display statistics for the active configuration.
For example:
sp_ctrl (irvspxu14:8567)> show config
Materialized Views Replicating:
Tables Replicating with Key:
“SCOTT”.”S1TEST2” KEY: KC
“SCOTT”.”S2TEST2” KEY: KC
“SCOTT”.”T1TEST2” KEY: KC
“SCOTT”.”T2TEST2” KEY: KC
Tables Replicating with no Key:
“TED”.”DEMO_SRC”
“TED”.”DEMO_DEST”
“SCOTT”.”FOOS”
filename : allscott
Datasource : o.ora920
Activated : 29-Jan-09 10:11:41
Actid : 1810
Total Objects : 160
Total Objects Replicating : 160
Total Objects Not Replicating : 0
View config summary in /splex/rr/svn/var92/log/ora920_config_log
The following is displayed if this command is executed before Capture is up:
sp_ctrl (irvspxu14:8567)> show config
Capture is not yet replicating the most recent activation
Re-issue this command when capture’s replication is current
Show Config provides the following statistics:
For more information about the objects in the configuration, view the SID_config_log, where SID is the ORACLE_SID of the instance. SharePlex prints activation results and error messages in this file, which resides in the log sub-directory of the SharePlex variable- data directory.
An example of the log file follows:
File Name :wild
Datasource :ora920
Activated :29-Jan-09 10:11:41
Actid :1810
Total Objects :9
Total Objects Replicating :9
Total Objects Not Replicating :0
Objects Replicating:
"SCOTT"."SRC_TEST1"
"SCOTT"."SRC_TEST2"
"SCOTT"."SS2_TEST1"
"SCOTT"."SRC_TEST3"
"SCOTT"."SRC_TEST4"
"SCOTT"."SS2_TEST2"
"SCOTT"."SRC_TEST5"
"SCOTT"."SRC_TEST6"
"SCOTT"."SS2_TEST3"
Objects Not Replicating:
Note:It may take a few seconds or longer to display the statistics.
Usage
| Supported sources: |
Oracle |
| Supported targets: |
All |
| Authorization level: |
Viewer (3) |
| Issued for: |
source system |
| Related commands: |
activate config, view config, verify config |
Syntax
| show config filename |
[ on host |
on host:portnumber |
on login/password@host |
on login/password@host:portnumber ] |
Syntax description
| filename |
The name of the configuration for which you want to view statistics. Configuration names are case-sensitive.
Example:
sp_ctrl(sysA)> show config sales |
Remote options
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.
| on host |
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 |
| on host:portnumber |
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 |
| on login/password@host |
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 |
| on login/password@host:portnumber |
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 |
show encryption key
Use the show encryption key command to view the AES encryption key that is being used by SharePlex. For more information about SharePlex encryption, see the SharePlex Administration Guide.
Usage
| Supported sources: |
Oracle |
| Supported targets: |
All |
| Authorization level: |
Operator (2) |
| Issues on: |
source system |
| Related commands: |
create encryption key, set encryption key, reset encryption key |
Syntax
| show encryption key |
[ on host |
on host:portnumber |
on login/password@host |
on login/password@host:portnumber ] |
Remote options
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.
| on host |
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 |
| on host:portnumber |
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 |
| on login/password@host |
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 |
| on login/password@host:portnumber |
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 |
