Ansicht
Dokumentation
dbs/inf/stmt_cache_size - size of statement cache
ABAP Short Reference CL_GUI_FRONTEND_SERVICES - Frontend ServicesThis documentation is copyright by SAP AG.
------------------------------------------------------------------------
| Parameter : dbs/inf/stmt_cache_size |
------------------------------------------------------------------------
------------------------------------------------------------------------
Short description: Size of statement cache
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter description : |
| ----------------------- |
Number of elements in the 'statement cache' for every work process.
The 'statement cache' can reduce the frequency of relatively
expensive PREPARE statements against the database quite considerably,
as the context information of these statements can be stored and
reused.
| |
Caution:
| -------- |
The effect of 'statement cache' is a reduction in expensive
PREPARE statements, but also a considerable increase in shared
memory usage on the database host.
------------------------------------------------------------------------
------------------------------------------------------------------------
Application area: Database
------------------------------------------------------------------------
------------------------------------------------------------------------
Unit: Number
------------------------------------------------------------------------
------------------------------------------------------------------------
Default value: 225
------------------------------------------------------------------------
------------------------------------------------------------------------
Who is permitted to make changes: SAP
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for operating systems: None |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for database systems: Informix |
------------------------------------------------------------------------
------------------------------------------------------------------------
Are other parameters affected or dependent: No
------------------------------------------------------------------------
------------------------------------------------------------------------
Valid entries, formats, areas: Integer values from 32 to 225
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short Description : size of statement cache
------------------------------------------------------------------------
------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter Type : I
------------------------------------------------------------------------
------------------------------------------------------------------------
| Changes allowed : X
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid for Operating System : *
------------------------------------------------------------------------
------------------------------------------------------------------------
| Dynamic switchable :
------------------------------------------------------------------------
------------------------------------------------------------------------
| Same on all Servers :
------------------------------------------------------------------------
------------------------------------------------------------------------
| Minimum : 32
------------------------------------------------------------------------
------------------------------------------------------------------------
| Maximum : 225
------------------------------------------------------------------------
TXBHW - Original Tax Base Amount in Local Currency SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up
This documentation is copyright by SAP AG.
Length: 4913 Date: 20240425 Time: 011239 sap01-206 ( 6 ms )