|
This section covers the database and the SoftExpert Suite database parameterizations. It is important to point out that these parameters are only recommendations based on the experience obtained from customer support.
Database
|
Type
|
Parameter name
|
Recommended value
|
Oracle
|
Database
|
cursor_sharing
|
EXACT
|
Oracle
|
Database
|
open_cursors
|
500 (minimum)
|
Oracle
|
Database
|
optimizer_mode
|
ALL_ROWS
|
Oracle
|
Database
|
pre_page_sga
|
False
|
Oracle
|
Database
|
session_cached_cursors
|
50 (minimum)
|
Oracle
|
Datafile
|
SOFTEXPERT_DATA
|
Autoextend on next 200M
|
Oracle
|
Datafile
|
SOFTEXPERT_INDEXES
|
Autoextend on next 50M
|
SQL Server
|
Server
|
Use AWE to Allocate Memory
|
False
|
SQL Server
|
Server
|
Boost SQL Server Priority
|
False
|
SQL Server
|
Server
|
Implicit Transactions
|
False
|
SQL Server
|
Server
|
nocount
|
False
|
SQL Server
|
Database
|
Extend .mdf file
|
200M
|
SQL Server
|
Database
|
Extend .ldf file
|
50M
|
SQL Server
|
Database
|
Auto close
|
False
|
SQL Server
|
Database
|
Auto create statistics
|
True
|
SQL Server
|
Database
|
Auto shrink
|
False
|
SQL Server
|
Database
|
Auto update statistics
|
True
|
SQL Server
|
Database
|
Page Verify
|
CHECKSUM
|
SQL Server
|
Database
|
Collation
|
Refer to "Database considerations" section
|
SQL Server
|
Database
|
Compatibility level
|
2012 or higher
|
PostgreSQL
|
Server
|
effective_cache_size
|
3 GB (minimum)
|
PostgreSQL
|
Server
|
shared_buffers
|
1 GB (minimum)
|
PostgreSQL
|
Server
|
checkpoint_segments
|
32
|
PostgreSQL
|
Server
|
checkpoint_completion_target
|
0.8
|
PostgreSQL
|
Server
|
work_mem
|
4 MB (minimum)
|
PostgreSQL
|
Server
|
max_connections
|
300 (minimum)
|
PostgreSQL
|
Server
|
wal_buffers
|
16 MB
|
PostgreSQL
|
Server
|
maintenance_work_mem
|
256 MB (minimum)
|
|
