Excluding the Multitenancy parameters here a list of the database start-up parameters that have been introduced in OE 11.x
In OE 11.0 there are no changes to the database start-up parameters.
In OE 11.1 these database start-up parameters were introduced for fine database tuning:
In the database engine
- LRU force skips (-lruskips)
- LRU alternate buffer pool force skips (-lru2skips)
For the servers network handling
- Message Wait (-Nmsgwait)
- Prefetch delay (-prefetchDelay) — Enable a delay when sending the first network message for queries with prefetch capabilities.
- Prefetch Factor (-preFetchFactor) — Specify a percentage of a network message required to contain prefetched data.
- Prefetch Num Recs (-prefetchNumRecs) — Specify the number of prefetch records placed in a network message.
- Prefetch Priority (-preFetchPriority) — Specify the number of prefetch records to add to an in-process query without polling.
In OE 11.2 these database startup parameters were changed and two introduced for fine tuning:
- The -pica maximum value is increased to 1000000.
- Maximum JTA Transactions (-maxxids) The minimum value is increased to 100, whether or not the database is enabled for JTA transactions.
- SQL rowid identifier(-SQLQuotedRowid) An SQL parameter that specifies how the quoted string rowid token is interpreted (as a column name or function).
In OE 11.3, 11.4 and 11.5 there are no changes to the database start-up parameters. |
