dbs/mss/par_stmt_cache_size - Size of cache for parameterized statements. Only for statistics.

CPI1466 during Backup   BAL_S_LOG - Application Log: Log header data  
This 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
------------------------------------------------------------------------


ABAP Short Reference   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.


Length: 4698 Date: 20120525 Time: 163556     triton ( 5 ms )