Cache and Control

Selecting the Cache and Control tab opens the Cache and Control page, which displays the available communication and control area (DCCA) options used for performance tuning. Cache and control settings are used to manipulate the amount of upper memory used by an active database, control the maximum number of users that can access an active database, and control locks. The journal buffer, data buffer, and system control area are all components of the database communication and control area (DCCA). Adjusting these settings influences database performance. The settings on this page are only applied to the server.

For more in-depth information on performance tuning, refer to chapter 15 in the Database Administrator's Guide.

Figure: The Cache and Control Page


Related topic:

The Main Console
Journal Buffer

Data Buffer

System Control Area

Maximum Number of Connections

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

Threshold of Lock Escalation from Row to Page

Display Mode

Lock Mode