Kbase P89401: List of SQL Startup parameters and their corresponding variable
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/05/2011 |
|
Status: Verified
GOAL:
List of SQL Startup parameters and their corresponding variable
GOAL:
SQL Startup parameters and their default values and ranges.
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
-SQLStmtCache corresponding to CACHED_STATEMENTS:
Number of prepared statements remembered in cache
Only grows. Large performance benefit.
Update if concurrent prepared statements > 100
Increase if error -210048 encountered
Valid range: 16 - 1024, Default: 100
-SQLCursors corresponding to OPEN_CURSORS:
Maximum number of cursors per thread
Very little runtime overhead
Increase is -20125 error encountered
Valid range: 16 - 512, Default: 50
-SQLStack corresponding to PROGRESS_STACK_MIN:
O/S stack size allocated to each thread
Increase if O/S complains of using too much stack
Valid range: 1000 - 2000K, Default: 1000K
Settings can cause unnecessary paging if set too high
-SQLTempBuff corresponding to TPE_MM_CACHESIZE:
In memory cache
Large values avoid paging to disk
Increase if ?no cache block? (-16003, -16005) error
Valid range: 100 - 200000 K
Default: 1000
-SQLTempDisk corresponding to TPE_MM_SWAPSIZE:
Size of disk swap space
Must increase if MM I/O type error (-16001) in .lg file
Unused space has no runtime overhead
Valid range: 5000 - 100000000K
Default: 500000K
-SQLTempPgSize corresponding to TPE_MM_BLOCKSIZE:
Governs I/O of cache to disk
Set to multiple of O/S I/O size
Increase if sorting very large records
Increase if ?row too big? (-16000) error during sort
Valid range: 4 - 256K
Default: 7K - It should be 8K