Setting Cache and Control Options |
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