topic Re: Clarification regarding SQL Trace. in Application Development and Automation Discussions

Clarification regarding SQL Trace.

Former Member — Thu, 23 Jul 2009 03:46:30 GMT

Hi,

This is regarding SQL Trace analysis.

If we set trace, it gives output like the following.

Please go through the below trace and you can note that there is a FETCH for table VVBAP and it consumes a lot of time.

As the Statement is blank, I could not analyse it further using ST05.

I understand that the below trace information is default standard. But could not understand as to why

STATEMENT is blank for this FETCH.


DURATION   	OBJECTNAME	OPERATION		RECORDS		RC		Statement

541		VVBAP		REOPEN		0		0	SELECT WHERE "MANDT" = '100' AND "VBEL
44,279		VVBAP		FETCH		5		1403    
41		VVBAP		REOPEN		0		0	SELECT WHERE "MANDT" = '100' AND "VBEL
45,803		VVBAP		FETCH		5		 1403
41		VVBAP		REOPEN		0		0	SELECT WHERE "MANDT" = '100' AND "VBEL

Thanks & Regards

Raghunahth L

Re: Clarification regarding SQL Trace.

Former Member — Thu, 23 Jul 2009 05:54:30 GMT

Hi,

the statement is blank, but the FETCH belongs to the REOPEN statement, there can be many FETCHES 44msec is also not really slow.

Please do not use the tracelist, it is much too detailed, on the screen, go to 'Trace List -> Summarize by SQL Statements' to list which shows

all executions in one line is much better for an analysis.

Most of the information is available in the blog

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

Siegfried

Re: Clarification regarding SQL Trace.

Former Member — Thu, 23 Jul 2009 08:14:32 GMT

Dear Siegfried,

Thanks for explaining about the FETCH.

And special thanks for your Blog. I could not find any detailed explaination about SQL Trace elsewhere in the SAP Help.

Thanks a lot again.

Best Regards

Raghunahth L

Re: Clarification regarding SQL Trace.

HermannGahm — Thu, 23 Jul 2009 08:24:24 GMT

Hi,


> I could not find any detailed explaination about SQL Trace elsewhere in the SAP Help.
>

sometimes it is not easy to find, but it is there:

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/d1/801fa3454211d189710000e8322d00/content.htm

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/d8/a61d94e4b111d194cb00a0c94260a5/content.htm

Kind regards,

Hermann