Ansicht
Dokumentation
dbs/mss/par_stmt_cache_size - Size of cache for parameterized statements. Only for statistics.
PERFORM Short Reference General Data in Customer MasterThis documentation is copyright by SAP AG.
------------------------------------------------------------------------
| Parameter: dbs/mss/par_stmt_cache_size |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short description: Size of cache for parameterized statements. |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter description: |
| ---------------------- |
| In transaction st04 -> Detailed Analysis -> SAP Stats on SPs there |
| is a way to monitor dynamically executed statements. This parameter |
| specifies how many of those statements are monitored. The worst |
| performing statements are placed in this cache. |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Application area: Database |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Unit: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Default value: 1000 |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Person(s) allowed to make changes: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for the operating systems: Windows NT |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Limitations for database systems: Microsoft SQL Server |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Are other parameters affected or dependent: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid entries, formats, areas: |
------------------------------------------------------------------------
------------------------------------------------------------------------
| Short Description : Size of cache for parameterized statements. Only for statistics.
------------------------------------------------------------------------
------------------------------------------------------------------------
| Applications Area : Database
------------------------------------------------------------------------
------------------------------------------------------------------------
| Parameter Type : I
------------------------------------------------------------------------
------------------------------------------------------------------------
| Changes allowed : X
------------------------------------------------------------------------
------------------------------------------------------------------------
| Valid for Operating System : Windows NT
------------------------------------------------------------------------
------------------------------------------------------------------------
| Dynamic switchable :
------------------------------------------------------------------------
------------------------------------------------------------------------
| Same on all Servers :
------------------------------------------------------------------------
------------------------------------------------------------------------
| Minimum : 10
------------------------------------------------------------------------
------------------------------------------------------------------------
| Maximum : 5000
------------------------------------------------------------------------
Fill RESBD Structure from EBP Component Structure ABAP Short Reference
This documentation is copyright by SAP AG.
Length: 4874 Date: 20240425 Time: 020027 sap01-206 ( 5 ms )