Ansicht
Dokumentation

dbs/inf/stmt_cache_reset_size - maximum size for automatic statement cache reset

dbs/inf/stmt_cache_reset_size - maximum size for automatic statement cache reset

TXBHW - Original Tax Base Amount in Local Currency   rdisp/max_wprun_time - Maximum work process run time  
This documentation is copyright by SAP AG.
SAP E-Book
------------------------------------------------------------------------
| Parameter : dbs/inf/stmt_cache_reset_size |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short description: Maximum size for automatic statement cache reset |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter description : |
| ----------------------- |
| Every R/3 process contains a memory area for database statements, |
| the 'statement cache'. Database statements stored here use memory |
| in the database. This memory is only released when a statement is |
| replaced by another. As a result, it is possible to 'shake-up' |
| the memory requirement in the database server. This can be controlled|
| by automatically resetting the statement cache of the R/3 processes |
| after a specified time period. |
| |
| If after this period (dbs/inf/stmt_cache_reset_time) the current |
| 'session' in the database is larger than the value of |
| dbs/inf/stmt_cache_reset_size, then the statement cache of the R/3 |
| process is reset. |
------------------------------------------------------------------------
------------------------------------------------------------------------
Application area: Database
------------------------------------------------------------------------
------------------------------------------------------------------------
| Unit : Bytes per session |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Default value: 10.000.000 |
------------------------------------------------------------------------
------------------------------------------------------------------------
Who is permitted to make changes: SAP
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for operating systems: None |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for database systems: Informix |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Other Parameters Affected or Dependent: |
| - dbs/inf/stmt_cache_reset_time |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid entries, formats, areas : : 0 - 2^31 |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Short Description : maximum size for automatic statement cache reset
------------------------------------------------------------------------

------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------

------------------------------------------------------------------------
| Parameter Type : I
------------------------------------------------------------------------

------------------------------------------------------------------------
| Changes allowed : X
------------------------------------------------------------------------

------------------------------------------------------------------------
| Valid for Operating System : *
------------------------------------------------------------------------

------------------------------------------------------------------------
| Dynamic switchable :
------------------------------------------------------------------------

------------------------------------------------------------------------
| Same on all Servers :
------------------------------------------------------------------------


General Material Data   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Length: 5027 Date: 20240426 Time: 172112     sap01-206 ( 7 ms )