dbs/db4/single_execution_reuse SAP Parameter attribute - Reuse single-execution SQL statements

dbs/db4/single_execution_reuse is a SAP Parameter attribute which is used to control Reuse single-execution SQL statements information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the attributes values .

dbs/db4/single_execution_reuse profile paramerter attributes

Parameter Name: dbs/db4/single_execution_reuse
Description: Reuse single-execution SQL statements
Default Value: 0
Parameter Type ( See IF_PARAMETER_TYPES): String(STRING)
Restriction Values:
Parameter Unit:
Parameter Group: Database
CSN Component: BC-DB-DB4
System-Wide parameter: No
Dynamic Parameter: No
Vector Parameter: No
Has Sub-Parameters: No
Check Function Exists: No

Parameter documentation

If you set this parameter, it deactivates parts of the effect of the database hint 'SINGLE_EXECUTION'. Although affected SQL statements are prepared in special, temporary SQL packages, existing statement resources are not necessarily released again immediately. Setting this parameter can have a significant effect on system performance.

See SAP Parameter Documentation for full SAP documentation for this profile parameter.