does ST05 record all the table operations?

[Former Member]

Dear all,

I try to use ST05 to trace the statement of table operations, but failed. (e.g. the data has been inserted into the table, but no relevant records be displayed in the ST05).

I'm sure I do the ST05 in correct way. So my question is does the ST05 record all the table operations except for the background job?

Regards,

Tony

[rahulkavuri]

http://help.sap.com/saphelp_nw04/helpdata/en/17/358df9c9fee2469105731e10756921/frameset.htm

hi try to this way again following the instructions

award points if found helpful

[Former Member]

Hi Tony,

ST05 captures operations DECLARE, PREPARE, OPEN, FETCH, EXEC, REOPEN and REEXEC.

for ex, EXEC will capture the SQL statements that modifies the database..like INSERT, MODIFY and UPDATE.

regards,

madhu

[Former Member]

ST05 shows that what tables are accessed and how much time it has taken and what type is has done etc....if u want more view...do this way....

after displaying the sql trace goto...

1) Using the menus from the Display Trace option, select Trace List -> Summarize Trace by SQL Statement

2) Using the menus from the Display Trace option, select Trace List -> Summarize Trace by Tables. Then choose the menu option Trace List -> Aggregate and click Yes in the pop-up for the All Tables option.