Database parameterization
This section covers parameterizations referring to the SoftExpert Suite database and external databases. It is important to point out that these parameters are just 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 | Servers | Use AWE to Allocate Memory | False |
| SQL Server | Servers | Boost SQL Server Priority | False |
| SQL Server | Servers | Implicit Transactions | False |
| SQL Server | Servers | 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 the "Database considerations" section. |
| SQL Server | Database | Compatibility level | 2012 or later |
| SQL Server | Database | Numeric Round-Abort | False |
| PostgreSQL | Servers | effective_cache_size | 3 GB (minimum) |
| PostgreSQL | Servers | shared_buffers | 1 GB (minimum) |
| PostgreSQL | Servers | checkpoint_segments | 32 |
| PostgreSQL | Servers | checkpoint_completion_target | 0.8 |
| PostgreSQL | Servers | work_mem | 4 MB (minimum) |
| PostgreSQL | Servers | max_connections | 300 (minimum) |
| PostgreSQL | Servers | wal_buffers | 16 MB |
| PostgreSQL | Servers | maintenance_work_mem | 256 MB (minimum) |
| PostgreSQL | Database | LC_COLLATE; LC_CTYPE | en_US.UTF-8 |