Skip to Content
0
Former Member
Jul 23, 2009 at 03:46 AM

Clarification regarding SQL Trace.

34 Views

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