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_reset_time - time interval for automatic statement cache reset

dbs/inf/stmt_cache_reset_time - time interval for automatic statement cache reset

Vendor Master (General Section)   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.
SAP E-Book
------------------------------------------------------------------------
| Parameter : dbs/inf/stmt_cache_reset_time
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short description : Time interval 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. |
| |
------------------------------------------------------------------------
------------------------------------------------------------------------
Application area: Database
------------------------------------------------------------------------
------------------------------------------------------------------------
| Unit : Seconds |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Default : 0 (deactivated) |
------------------------------------------------------------------------
------------------------------------------------------------------------
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_size |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid entries, formats, areas : : 0 - 2^31 |
------------------------------------------------------------------------

------------------------------------------------------------------------
| Short Description : time interval for automatic statement cache reset
------------------------------------------------------------------------

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

------------------------------------------------------------------------
| Parameter Type : T
------------------------------------------------------------------------

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

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

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

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


PERFORM Short Reference   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

Length: 4687 Date: 20211201 Time: 185614     sap01-206 ( 6 ms )