"Turn" ST05

First, SQL Trace

With SQL tracing, you can query exactly which database tables the data originates from,

For example, you can query the database tables involved in a transaction (or several transactions). To reduce the amount of work in the final query results, to display the previous step of the data that you want to display on the screen,

First go to ST05, click Activate Trace, then perform the action before displaying the data, after the screen data display, back to ST05, click Deactivate Trace,

Finally click on the display Trace, you can specifically query the data from which database tables!

1, outside the network 110 environment, enter the system, enter the ST05, click the Activate Trace option, start to enter the tracking. As shown in the following:

St05-01.jpg (67.99 KB, download number: 4)

Download attachments

2014-2-17 16:49 Upload

2, enter the transaction FNVM, enter the contract modification interface:

Fnvm.jpg (37.57 KB, download number: 4)

Download attachments

2014-2-17 16:49 Upload

3. After completing the transaction, enter the st05 transaction, click Deactivate Trace, then click on the display trace as shown:

St05-02.jpg (113.5 KB, download number: 4)

Download attachments

2014-2-17 16:49 Upload

St05-03.jpg (351.88 KB, download number: 4)

Download attachments

2014-2-17 16:49 Upload

4, the query result description: The field description is as follows:

Duration: Duration, Unit: microseconds

OBJ. Name: Table name

Op.: Operation type

Statement: The SQL statement that was executed.

Two, Enqueue Trace

With Enqueue Trace, the system can record all the lock and unlock declarations for a user or a group of users. Trace records can contain information such as the following:

• Locking objects involves the indication that
• Name of the program to set the lock
• Types of Locks
• Owner of the Lock
• Setting the lock and unlocking time

1, outside the network 110 environment, enter the system, input st05, select Enqueue Trace
2. The following operations are the same as SQL Trace operations

Enqueue trace.jpg (91.4 KB, download number: 4)

Download attachments

2014-2-17 18:47 Upload

3, the query results show:

The fields are described as follows:

Duration: Time the lock operation was executed

OBJ. Name: Name of the lock

Op.: Lock operation

Recs.: Number of granules in the lock object.

RC: The encoding returned, 0 indicates that the lock operation was successful, and 1 indicates that the operation was unsuccessful (lock multiple items should be locked or partially locked).

Statement:this column lists the granules for the lock request
Third, RFC Trace

With RFC tracing, you can track the remote calls that an application performs or the SAP system executes in a call, and you can display and parse trace logs in the trace file. The tracked record contains the following:

• Which function Modules is called in the program
• Whether the RFC executed successfully
• The time it took to invoke the process remotely
• The communication token for the RFC, client or server.
• The instance of the remote call.
• Technical data
• The number of bits sent and received in the RFC.

1, in the external network 110 environment, enter the system, enter the ST05, select RFC Trace
2. The following operations are the same as SQL Trace operations

RFC trace.jpg (93.57 KB, download number: 4)

Download attachments

2014-2-17 18:51 Upload

3, the query results show:

The fields are described as follows:

Duration: The time that the remote call ran

OBJ. Name: A function function instance that is called remotely for short.

Op.: Client or Server.

Recs.: There are five types of RFC trace records, respectively: 1,2,3,4,5.

RC: Returns the log encoding of the remote call. If 0, the remote call succeeds, or if it is not equal to 0, the remote call has an error.

Statement: The name of the local instance, the name of the remote instance, the name of the called function Module, and the number of bits sent and received.

iv. Table Buffer Trace

With table buffer tracking, you can monitor access to the table buffers and buffer loading and unloading. The table buffer trace can get the following information:

• Which buffer accesses your statement executes
• Which buffer operations is used
• How the buffer is managed

1, in the external network 110 environment, enter the system, enter the st05, select the buffer Trace
2. The following operations are the same as SQL Trace operations

TABLE BUFFER trace.jpg (276.99 KB, download number: 4)

Download attachments

2014-2-17 18:55 Upload

3, the query results show:

The fields are described as follows:

Duration: Duration

OBJ. Name: Table name

Op.: Displays the ability to perform specific table operations in the buffer.

Recs.: Number of records read.

Rc:0 indicates that the function is performed correctly; 64 indicates that no record is found, that is, the number of records is zero, 256 indicates that the table buffer is accessible (the buffer type is R, P), the buffer type S, C, O, and M indicate that an object has been inserted; 1024 indicates that the record is not in the buffer. Statement: The type of buffer, key length, key value.
Database Operations measured by SQL Trace
The SQL Trace analysis helps in measuring the execution time of the following data base operations that is performed when Executing an SQL statement.

• Declare:this Operation declares a new cursor and assigns the SQL statement to that cursor created.
• Prepare:this operation converts the SQL statement into native SQL and frames out a execution plan for that statement.
• Open:this operation opens the declared cursor and passes the parameters for database access.
• Fetch:this operation passes one or more data records fetched to the database interface of the R/3 system.
• Reopen:once A new SELECT statement is brought in and this operation opens the cursor previously declared for previous SE Lect statement and performs new parameter passing to the database.
• Exec:passes the parameters for the database statement, and executes the statements that change data in the database (such As UPDATE, DELETE, or INSERT).

"Turn" ST05