Chat now with support
Chat with Support

SharePlex 8.6.6 - Administration Guide

About this Guide Conventions used in this guide Overview of SharePlex Run SharePlex Run multiple instances of SharePlex Execute commands in sp_ctrl SharePlex parameters Prepare an Oracle environment for replication Create a configuration file Configure replication to Open Target targets Configure a replication strategy Configure partitioned replication Configure named queues Configure SharePlex to maintain a change history target Replicate Oracle DDL Set up error handling Transform data Configure SharePlex security features Activate replication in your production environment Monitor SharePlex Prevent and solve replication problems Repair out-of-sync Data Procedures to maintain Oracle high availability Make changes to an active replication environment Apply an Oracle application patch or upgrade Back up Oracle data on the source or target Tune the Capture process Tune the Post process Appendix A: Peer-To-Peer Diagram Appendix B: SharePlex environment variables

show export

Use the show export command to view statistics about the Export process. This command keeps a record of the number of messages sent to target systems by all Export processes on the local machine, as well as optional statistic about Export performance. The message count begins over again whenever Export stops and starts again.

Note: Typically, a message approximately corresponds to a SQL operation, but there can be multiple messages for one operation on a LONG or LOB column, and there could be one record for numerous operations in an array insert. A message also can be an internal SharePlex operation.

Usage

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

Syntax

Basic command Command options Remote options

show export

[detail]

[queue queuename]

[ on host |

on host:portnumber |

on login/password@host |

on login/password@host:portnumber ]

Syntax description

Component

Description

queue queuename Constrains the output to a specific named Export queue.
detail

Shows the following statistics:

  • Highest rate since the Export process was activated and the date/time it occurred
  • Highest rate since Export was started and the date/time it occurred
  • Current rate reported as KB/sec and measured as the total KB in a 60 second time slice
  • Average packet size during the last 60 second time slice
  • Number of packets sent during the last 60 second time slice
  • Average TCP send time during the last 60 second time slice
  • Largest deviation from average during the last 60 second time slice
  • Number of packets that deviated more than 50% during the last 60 second time slice

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

Example

Host   : abcl23
Queue  : abcl23
                           Kbytes
Target     Status          Exported     Since              Total       Backlog
---------- --------------- ------------ ------------------ ---------- ----------
abcl23.abc Running                 1063 18-Aug-14 17:05:29       1082          0

  Since activated
    Transmission rate                       : 5 Kb/sec
    Highest transmission rate               : 10 Kb/sec Mon Aug 18 14:45:49 2014
    Average packet size                     : 680 bytes
    Average send time                       : 68 microseconds

  Since export started
    Transmission rate                       : 4 Kb/sec
    Highest transmission rate               : 2 Kb/sec Mon Aug 18 17:07:18 2014
    Average packet size                     : 615 bytes
    Average send time                       : 16 microseconds

  During the last 27 seconds:
    Transmission rate                       : 25 Kb/sec
    Average packet size                     : 678 bytes
    Number of packets                       : 1081
    Average send time                       : 19 microseconds
    Largest deviation from average          : 6002 microseconds
    Send times deviating by more than %23   : %0.9
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating