this is not neccesarily critical but strikes me as rather odd for SAP applications using the Oracle RDBMS.
"BW" seems to issue SQL-Statements without dynamic variable binding, that is I can see SQL-Statement with literals:
SELECT "S27"."/BIC/ZBCS_VER1" AS "ZBCS_VER1" , ...
AND ( ( "D1"."SID_ZBCS_VER1" = 2 ) ) AND ( ( "D1"."SID_ZBCS_VER2" = 6 ) ) AND (
( "D1"."SID_ZBCS_VER3" = 3 ) ) ) )
Usually Statements shouldn't use literals, so that the query looks like this:
"D1"."SID_ZBCS_VER1" = :1
The negative effects of this are among others higher memory consumtion and higher parse rates.
These statements stem from program UCUWB000 in our SEM-BCS system.
I've not come accross this before when analysing SQL-Statements issued by SAP applications, so this seems to be something specific to BW or SEM-BCS.
Can anyone share his / her knowlede on this?
Thanks a lot,