Setting Cache and Control Options

 How To

Cache and control settings are used to manipulate the amount of memory used by an active database, control the maximum number of users that can access the active database, and control locks. Adjusting these settings influences database performance. For more information on performance tuning, refer to the Database Administrator's Guide. The Cache and Control page exactly corresponds to the Cache and Control page in the JConfiguration Tool. Please refer to the JConfiguration Tool Reference for more information on Cache and Control.

Figure:The Cache and Control page of the Start Database Advanced Settings window


Related topic:

Starting a Database: Advanced Settings
Size of Journal Buffer

Size of Data Buffer

Size of System Control Area

Maximum Number of Connections

Catalog Cache Turbo Mode

Size of IVF Required Memory
Threshold of lock Escalation from Page to Table

Threshold of lock Escalation from Row to Page

Display Mode of SQL Command Monitor

Lock Mode

Cache and Control