Clarification regarding SQL Trace.

[Former Member]

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

[former_member194613]

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

[Former Member]

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

[former_member192616]

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