trace capture
Use the trace capture command to output Capture processing and performance statistics to a trace file.
The Capture trace includes:
- Details of the trace itself
- Time that Capture spent on various tasks overall and per thread
Usage
| Supported sources: |
Oracle |
| Supported targets: |
All |
| Authorization level: |
Operator (2) |
| Issues for: |
source system |
| Related commands: |
trace read, trace post |
Syntax
| trace capture |
[minutes]
[for datasource] |
[ on host |
on host:portnumber |
on login/password@host |
on login/password@host:portnumber ] |
Syntax description
| minutes |
The number of minutes for which you want to run the trace. The default is 15 minutes. |
| for datasource |
The datasource for which you want to run the Capture trace. Only required if running multiple Captures in the same SharePlex instance. Must follow minutes, if used. |
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 |
Output
When the trace is complete, the process writes the trace data to a file in the log subdirectory of the variable-data directory in the following format:
For example:
orcl_ocap_trace_Sep30_15_24_2014
where: orcl is the datasource and ocap is the name for the Capture process.
Example
The following command runs the trace for datasource myora for one minute.
trace capture 1 for myora
This command produces trace output similar to the following:
trace post
Use the trace post command to output Post processing and performance statistics to a trace file.
The Post trace includes:
- Details of the trace itself
- Statistics on transaction activity
- Detail statistics per operation type
Usage
| Supported sources: |
Oracle |
| Supported targets: |
All |
| Authorization level: |
Operator (2) |
| Issues for: |
target system |
| Related commands: |
trace capture, trace read |
Syntax
| trace post |
[minutes]
[for datasource-datadest]
[queue queuename] |
[ on host |
on host:portnumber |
on login/password@host |
on login/password@host:portnumber ] |
Syntax description
| minutes |
The number of minutes for which you want to run the trace. The default is 15 minutes. |
| for datasource-datadest |
Constrains the trace to a specific Post process, as identified by the source and target datastores.
- Required if running multiple Post processes in the same SharePlex instance (replication from different sources) or if running multiple Post processes to different target databases. Must follow minutes, if used.
-
datasource is expressed as o.SID where SID is an ORACLE_SID.
-
datadest is expressed as one of the following, depending on the target:
o.ORACLE_SID
r.database_name
x.kafka
x.jms
x.file |
| queue queuename |
Constrains the trace to the Post process that is associated with the specified named queue. |
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 |
Output
When the trace is complete, the process writes the trace data to a file in the log subdirectory of the variable-data directory in the following format:
For example:
orcl_orcl2_opo_trace_Feb_5_17_24_2014
where: orcl is the source datasource and orcl2 is the target datasource and opo is the name for the Post process.
Example
The following command runs the trace for datasources myora and myora2 for one minute.
trace post 1 for myora-myora2
This command produces trace output similar to the following:
trace read
Use the trace read command to output Read processing and performance statistics to a trace file.
The Read trace includes:
- Details about queries that were made to obtain the values of keys
- Statistics to show the time that Read spend on various processing tasks
Usage
| Supported sources: |
Oracle |
| Supported targets: |
All |
| Authorization level: |
Operator (2) |
| Issues for: |
source system |
| Related commands: |
trace capture, trace post |
Syntax
| trace read |
[minutes]
[for datasource] |
[ on host |
on host:portnumber |
on login/password@host |
on login/password@host:portnumber ] |
Syntax description
| minutes |
The number of minutes for which you want to run the trace. The default is 15 minutes. |
| for datasource |
The datasource for which you want to run the trace. Only required if running multiple Capture and Read processes in the same SharePlex instance. Must follow minutes, if used. |
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 |
Output
When the trace is complete, the process writes the trace data to a file in the log subdirectory of the variable-data directory in the following format:
For example:
orcl_ord_trace_Sep30_13_07_2014
where: orcl is the datasource and ord is the name for the Read process.
Example
The following command runs the trace for datasource myora for one minute.
trace read 1 for myora
This command produces trace output similar to the following:
truncate log
Use the truncate log command to truncate (remove all data from) the Event Log and trace log files in the log sub-directory in the SharePlex variable-data directory. These logs accumulate data and eventually can consume a large amount of disk space. The truncate log command allows you to truncate the logs after the data has outlived its usefulness. This command does not affect replication. You can issue it while replication is active and data is in the queues.
Truncating logs when sp_eventmon is running
When the sp_eventmon monitoring script is running, issue the truncate log command and then delete the sp_cop_name.mrk file, where sp_cop_name is the value used in the -s argument when the script was run. This file is in the util sub-directory of the SharePlex product directory.
Important: The truncate log command deletes all entries from the logs. Quest Technical Support refers to the information in the logs when you make a support call, so try to retain the data as long as possible.
Usage
| Supported sources: |
Oracle |
| Supported targets: |
All |
| Authorization level: |
Administrator (1) |
| Issued for: |
source or target system |
| Related commands: |
none |
Syntax
| truncate log |
[ 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 |
