Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL OneDB™ database servers.
Performance GuideThe HCL OneDB™ Performance Guide describes how to configure and operate your HCL OneDB™ database server to improve overall system throughput and to improve the performance of SQL queries.
Effect of configuration on memory utilizationThe combination of operating-system and HCL OneDB™ configuration parameters can affect memory utilization.
Configuration parameters that affect memory utilizationA large number of configuration parameters in the ONCONFIG file affect memory utilization and performance.
The SHMTOTAL configuration parameter and memory utilizationThe SHMTOTAL configuration parameter places an absolute upper limit on the amount of shared memory that an instance of the database server can use.

The SHMTOTAL configuration parameter and memory utilization

The SHMTOTAL configuration parameter places an absolute upper limit on the amount of shared memory that an instance of the database server can use.

If the SHMTOTAL configuration parameter is set to 0 or left unassigned, the database server continues to attach additional shared memory as needed until no virtual memory is available on the system.

You can usually set the SHMTOTAL configuration parameter to 0, except in the following cases:

You must limit the amount of virtual memory that the database server uses for other applications or other reasons.
Your operating system runs out of swap space and performs abnormally. In this case, you can set SHMTOTAL to a value that is a few megabytes less than the total swap space that is available on your computer.
You are using automatic low memory management.