topic Re: does ST05 record all the table operations? in Application Development and Automation Discussions

does ST05 record all the table operations?

Former Member — Mon, 05 Feb 2007 15:42:14 GMT

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

Re: does ST05 record all the table operations?

rahulkavuri — Mon, 05 Feb 2007 15:46:02 GMT

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

Re: does ST05 record all the table operations?

Former Member — Mon, 05 Feb 2007 15:47:57 GMT

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

Re: does ST05 record all the table operations?

Former Member — Mon, 05 Feb 2007 15:49:18 GMT

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.