topic regarding ST05 in Application Development and Automation Discussions

regarding ST05

Former Member — Thu, 15 May 2008 19:40:34 GMT

hi gurus,

can some one please tell me how to make use of ST05 sql trace,

please give me a step by step process what to do after going to tcode ST05.

thanks.

Re: regarding ST05

Sm1tje — Thu, 15 May 2008 19:44:35 GMT

1. Go to ST05 enter start the trace (mark checkbox SQL trace).

2. Now go to the transaction for which a trace should be performed. Make sure that you have already opened this session before starting the trace.

3. Process the transaction as far as you want.

4. Stop the trace in ST05 and display it.

5. Overview of all relevant tables which have been accessed during transaction.

Re: regarding ST05

Former Member — Thu, 15 May 2008 19:47:42 GMT

Hi,

This is used for SQL Tracing.

whatever you want to trace, open in another session - say session 2, and in one session open st05 - say session 1 - from the step you want to start your trace, go to that step in session 2, and now go to session 1 and click on trace on, go to session2 , do all steps, once u r done, go to session 1 with sql trace and disable trace, then view trace. - It will display you all SQL statements and the tables it checked for all your steps in session 2.

Award me points if it helps....

Thanks,

Sheel

Re: regarding ST05

Former Member — Thu, 15 May 2008 19:50:35 GMT

hi sanjana..

SQL Trace

SQL trace(ST05) provides the developer with the ability to analyse database select statements. Simply execute ST05

to turn on SQL trace, then execute the statement/program you want to analyse. Now turn off SQL trace using ST05

and click on list trace to view the details.

You can also perform traces on other items such as authorisation objects.

Authorisation trace analysis 1. Open two sessions

2. Execute transaction ST01 in one of the sessions

3. Select the authorisation checkbox, note the other traces

you can perform (SQL, RFC, Table Buffer etc)

4. Click the 'Trace On' button

5. Within your other session execte the transaction/report

you want to trace or get the user in question to do it

6. Return to the session where you turned the trace on and

click on 'Trace Off' otherwise it will continue to record

all athorisation checks

7. Click on the 'Analysis' button

8. Enter appropriate data into selection screen such as

Username, type of trace records (i.e. Authorization check)

9. Click on the Execute button.

10. Report displaying trace results will now be displayed

http://www.sapdevelopment.co.uk/perform/perform_sqltrace.htm

Some useful transaction related to this are ..

ST01 SAP system trace

ST02 Buffer statistics.

ST03 Workload analysis.

ST04 Database performance analysis.

ST05 SQL trace .

ST06 Operating system monitor ...

From the recorded SQL trace you can deduce:

· Which SQL statements your application carries out

· Which values the system uses for specific database accesses and changes

· How the system translates ABAP OPEN SQL commands (such as

SELECT) into standard SQL commands

· Where your application positions COMMIT statements

· Where your application makes repeated database accesses

· What database accesses or changes occur in the update section of your

application

Look at the below links, you will get the idea

http://help.sap.com/saphelp_erp2005/helpdata/en/d1/801f89454211d189710000e8322d00/content.htm

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

regards,

venkat .