SQL TRACE

[Former Member]

How to perform an sql trace on the any transaction.

[Former Member]

st05

Goto transaction ST05. Press TRACE ON.

Execute your transaction .

Come back to this screen and click TRACE OFF.

Then check the trace details.

[Former Member]

Well using SQL trace

like as follows:

Goto transaction ST05. Press TRACE ON.

Execute your transaction .

Come back to this screen and click TRACE OFF.

Then check the trace details.

-

---

You end up getting unnecessary details

Lets say you have to analyze your particular SQL query,

1. put a breakpoint at the select statement and execute the transaction , as it stops at your breakpoint , run SQL trace in seperate session.

2. Trace ON

3. Execute the select statement.

4. Trace OFF

5. Analyze.

In this way you can analyze your particular select query

Regards

Alok Pathak

[Former Member]

hi

good

go to st05

click on SQL trace check box

click on Trace On button on the right hand side

click om explain one SQL request and give a sql statement

click on explain button

it ll give you the output.

thanks

mrutyun

[Former Member]

Hi Satish,

Pls check links like:

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

http://help.sap.com/saphelp_bw30b/helpdata/en/d1/801f89454211d189710000e8322d00/frameset.htm

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

Cheers

VJ

[Former Member]

hi Satish,

Check

<b>SQL trace</b>http://help.sap.com/saphelp_47x200/helpdata/en/d1/801f7c454211d189710000e8322d00/content.htm

Regards,

Santosh