...

1. If the error occurs during query execution, check the "EXECUTE_STMT_MEMORY_MAXIMUM" property value with the following SQL statement.

iSQL> set vertical on;
iSQL> select name, value1 from v$property where name='EXECUTE_STMT_MEMORY_MAXIMUM';
NAME   : EXECUTE_STMT_MEMORY_MAXIMUM                         
VALUE1 : 1073741824  

2. Increase the property value appropriately with the ALTER statement. (The unit is byte.)

The following is an example of setting to 2G.

iSQL> alter system set EXECUTE_STMT_MEMORY_MAXIMUM = 2147483648;
Alter success.

3. The above command is applied to the entire server after execution, but it is applied as the setting value of the property file when Altibase is restarted.

Therefore, to apply it permanently, the property value must be changed in the property file as well.

Change the property value in the $ALTIBASE_HOME/conf/altibase.properties file as above.

Reference

...

1. The EXECUTE_STMT_MEMORY_MAXIMUM property specifies the maximum value, and memory is not allocated as much as the preset value.

   However, the memory usage may increase as much as the set value, so be careful when setting it.

   Therefore, it is recommended to increase it appropriately empirically rather than setting it large in advance.

    

2. The "Insufficient memory" error can be a number of memory allocation failure errors in addition to the cases described here.

   Therefore, if the above solutions do not solve the problem, please contact Altibase Technical Support.