SQL Trace

[Former Member]

pl..tell me how to use SQL trace and observe the results..

[Former Member]

SQL trace

http://help.sap.com/saphelp_47x200/helpdata/en/d1/801f7c454211d189710000e8322d00/content.htm

[Former Member]

hi,

Submit ABAP report with SQL traces

You use ST05, Trace Request, to do a SQL trace.

When using SQL trace, it is good to run the program in debugger and just before you execute the SQL, go to ST05 in another session and turn the trace on.

After, or when, the SQL is finished, you can turn the trace off.

Then click on List Trace to see the details.

This is the way to control the traces.

If you just turn the trace on and then execute the program, you will get everything and will be overflooded with unnecessary information.

Hope this helps, Do reward.

[Former Member]

why do not just read the most recent questions, the same question was asked yesterday!

I can only recommend you my blog, it explains all you need

/people/siegfried.boes/blog/2007/09/05/the-sql-trace-st05-150-quick-and-easy

> When using SQL trace, it is good to run the program in debugger and just before you execute the SQL, go to ST05 in another > session and turn the trace on.

> After, or when, the SQL is finished, you can turn the trace off.

> Then click on List Trace to see the details.

> This is the way to control the traces.

> If you just turn the trace on and then execute the program, you will get everything and will be overflooded with unnecessary

> information.

sorry, bad idea, much to complicated and misleading! Often you don't know what statement creates the problem, and usually it is not one problem.

Read the blog carefully, the condensed view (section 3 ) makes this complicated approaches obsolete.

Siegfried

[Former Member]

Hi,

ST05 -> SQL Trace can be used for performing SQL statement analysis..

Check this link..

http://www.sapbrain.com/TOOLS/SQLTRACE/SQL_TRACE.html

Refer

https://forums.sdn.sap.com/click.jspa?searchID=10333986&messageID=3558350

Regards

Kiran Sure