Chat now with support
Chat with Support

SharePlex 8.6.6 - Reference Guide

About this guide Conventions used in this guide SharePlex commands SharePlex parameters SharePlex utilities Appendix B: SharePlex environment variables

show activate

Use the show activate command to view the status of activation activity on a source system. Concurrent activations for different datasources are displayed in the order that they started.

 

The command displays:

  • The configuration’s name, datasource, and activation ID number, and the date and time it was activated.
  • The number of tables that SharePlex is processing concurrently. This value depends on either the default number of threads for the activate config command (based on the value of the SP_OCF_THREAD_COUNT parameter) or that command’s [threads=n] option, if used. See “activate config” for more information about multi-threaded activation.
  • The number of tables in the processing batch whose activations completed successfully.
  • The number of tables in the processing batch whose activations failed.
  • The names of the tables in the processing batch that are still being processed.
  • The tables for which SharePlex is waiting to receive a lock. The value is shown next to the name of the table in the list of tables still being processed.

The following are possible notice messages:

Message Reason
No current activation process. Activation is already finished. Use the show config command to view the active configuration. The activation is finished.
No current activation process. Activation is already finished. The activate config command was never issued
No tables to activate.

This message is generated when an active configuration is reactivated without being changed first. The show activate command generates output only when you activate the following:

  • A new configuration.
  • An edited configuration that contains new objects.
   

The show activate command remains in control of the sp_ctrl prompt until the entire activation is finished. To issue other commands in sp_ctrl while activation is in process, open another session of sp_ctrl.

Usage

Supported targets: All
Authorization level: Viewer (3)
Issued for: source system
Related commands: activate config, show config, view config

Syntax

Basic command Command options Remote options
show activate

[for datasource]

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax description

Component Description
show activate Without options, shows all activation activity.
for datasource

Use this option to show activation for a specific data source when replication is active for multiple databases on a system.

The default show activate behavior without this option is to show the activation processes for all active configurations.

datasource is expressed as o.SID, where SID is an ORACLE_SID.

Example:

sp_ctrl(sysA)> show activate 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.

Option Description
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 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 data source, 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.

Statistic Description
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).

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

Usage

Supported targets: All
Authorization level: Viewer (3)
Issued for: source system
Related commands: show export, show import, show post, show read

 

Syntax
Basic command Command options Remote options
show capture

[detail] [for datasource]

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax description

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

    Example:

    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.

    Option Description
    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:

    “SCOTT”.”V5_ROWID”

    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:

    • Config: The configuration name.
    • Datasource: The Oracle instance containing the objects being replicated.
    • Activated: The date and time that the configuration was activated.

    • Actid: The activation ID number for the configuration (mostly for use by Quest Software. Technical Support).
    • Total Objects: The number of objects in the configuration file.
    • Total Objects Replicating: The number of objects in the configuration that are replicating.
    • Total Objects Not Replicating: The number of objects in the configuration for which activation failed, and therefore are not replicating.
    • List of the tables in replication and having a primary or unique key, in replication and having no key, and not in replication

    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 targets: All
    Authorization level: Viewer (3)
    Issued for: source system
    Related commands: activate config, show activate, view config, verify config

    Syntax

    Basic command Remote options
    show config filename

    [ on host |

    on host:portnumber |

    on login/password@host |

    on login/password@host:portnumber ]

    Syntax description

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

    Option Description
    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 detailed instructions for configuring SharePlex encryption, see Encrypt data across the network in the SharePlex Administration Guide.

    Usage

    Supported targets: All
    Authorization level: Operator (2)
    Issues on: source system
    Related commands: create encryption key, set encryption key, reset encryption key

    Syntax

    Basic command Remote options
    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.

    Option Description
    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

    Related Documents