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

Basic command	Command options	Remote options
trace read	[minutes] [for datasource]	[ on host | on host:portnumber | on login/password@host | on login/password@host:portnumber ]

Syntax description

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

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

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:

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: