SAP TABLES

dbs/db4/single_execution_threshold SAP Parameter attribute - Maximum number of SQL statements per single-execution package








dbs/db4/single_execution_threshold is a SAP Parameter attribute which is used to control Maximum number of SQL statements per single-execution package 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_threshold profile paramerter attributes


Parameter Name: dbs/db4/single_execution_threshold
Description: Maximum number of SQL statements per single-execution package
Default Value: 2000
Parameter Type ( See IF_PARAMETER_TYPES): Integer range(INT_RANGE)
Restriction Values: 0 2147483647
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

SQL packages are restricted in size, depending on the database version. You can use this parameter to define the maximum number of SQL statements for each temporary SQL package. It can be useful to reduce the default value if statements are exceptionally complex, meaning that the estimated space required for each statement is not sufficient. (Temporary SQL packages means packages in the library R3<(> <<)>sid>Y0000, which include SQL statements with the database hint 'SINGLE_EXECUTION'. For background information, see SAP Note 481868.)

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