Documentation View

We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

dbs/inf/stmt_cache_size - size of statement cache

dbs/inf/stmt_cache_size - size of statement cache

Fill RESBD Structure from EBP Component Structure   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.
SAP E-Book
------------------------------------------------------------------------
| 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
------------------------------------------------------------------------


ABAP Short Reference   Addresses (Business Address Services)  
This documentation is copyright by SAP AG.

Length: 4913 Date: 20211205 Time: 162547     sap01-206 ( 5 ms )