SAP Tuning

SELECT T_00.VBELN,
T_00.AUART,
T_00.KUNNR,
T_00.SPART,
T_00.VKBUR,
T_00.VKGRP,
T_00.ERDAT,
T_00.VKORG,
T_00.VTWEG,
T_01.POSNR,
T_01.MATNR,
T_01.LGORT,
T_01.WERKS,
T_01.UEPOS,
T_01.VRKME,
T_01.KBMENG,
T_01.KWMENG,
T_01.VSTEL,
T_01.MATKL,
T_04.NAME1,
T_05.MAKTX,
T_06.MTART,
T_06.ZZMAKTX,
T_01.MATKL
FROM VBAK T_00
INNER JOIN
VBAP T_01
ON T_01.MANDT = '700' AND T_01.VBELN
= T_00.VBELN
INNER JOIN
MARD T_02
ON T_02.MANDT = '700'
AND T_01.MATNR = T_02.MATNR
AND T_01.WERKS = T_02.WERKS
AND T_01.LGORT = T_02.LGORT
INNER JOIN
VBUP T_03
ON T_03.MANDT = '700'
AND T_03.VBELN = T_01.VBELN
AND T_03.POSNR = T_01.POSNR
INNER JOIN
KNA1 T_04
ON T_04.MANDT = '700'
AND T_04.KUNNR = T_00.KUNNR
AND T_04.LAND1 = 'TR'
INNER JOIN
MAKT T_05
ON T_05.MANDT = '700'
AND T_05.MATNR = T_01.MATNR
AND T_05.SPRAS = 'T'
INNER JOIN
MARA T_06
ON T_06.MANDT = '700' AND T_06.MATNR =
T_01.MATNR
WHERE T_00.MANDT = '700'
--AND T_00.KUNNR = '0012020076'
AND T_00.AUART = 'ZD01'
AND T_00.VKORG = '1000'
AND T_01.VSTEL = '1000'
AND ( T_03.BESTA = 'A'
OR T_03.BESTA = 'B'
OR T_03.BESTA = 'C')
AND T_00.LIFSK <> 'Z1'
------------------------------------------
select * from v$parameter
where name like '%user_dump%'
-------------------------------------
col name format a10

col value_string format a50


select name, datatype, value_string

from v$sql_bind_capture

where sql_id='drgya7ynf0tn6' and child_number=0

order by position;
-------------------------------------------
select lpad(' ', level ) || operation operations,

object_name, options, cardinality

from (select * from v$sql_plan

where sql_id='drgya7ynf0tn6'

and child_number=0)

connect by prior id=parent_id

start with id=0

order by id, position;
--------------------------------------------
select NAME, VALUe_STRiNG from V$SQL_BIND_CAPTURE
where SQL_ID='drgya7ynf0tn6'