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