topic SQL TRACE in Application Development and Automation Discussions

SQL TRACE

Former Member — Tue, 22 Aug 2006 05:41:52 GMT

How to perform an sql trace on the any transaction.

Re: SQL TRACE

Former Member — Tue, 22 Aug 2006 05:44:44 GMT

st05

Goto transaction ST05. Press TRACE ON.

Execute your transaction .

Come back to this screen and click TRACE OFF.

Then check the trace details.

Re: SQL TRACE

Former Member — Tue, 22 Aug 2006 06:28:13 GMT

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

Re: SQL TRACE

Former Member — Tue, 22 Aug 2006 06:30:28 GMT

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

Re: SQL TRACE

Former Member — Tue, 22 Aug 2006 09:00:44 GMT

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

Re: SQL TRACE

Former Member — Tue, 22 Aug 2006 09:04:08 GMT

hi Satish,

Check

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

Regards,

Santosh