...
1. Check the maximum value of disk temp tablespace
TEMP_MAX_PAGE_COUNT should be set on the assumption that all disk temporary tablespaces will be used to the maximum. Therefore, check the sum of the maximum values of all disk temporary tablespaces created in the Altibase server with the following query.
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT 'DISK_TEMP_TBS_MAX_SUM'
, SUM(DECODE(F.MAXSIZE, 0, F.CURRSIZE, F.MAXSIZE)*TBS.PAGE_SIZE) AS 'MAX_SIZE(BYTE)'
FROM V$DATAFILES F,
V$TABLESPACES TBS
WHERE F.SPACEID = TBS.ID
AND TBS.TYPE IN (5, 6); |
...
2. Calculate TEMP_MAX_PAGE property appropriate value
The unit of the TEMP_MAX_PAGE_COUNT property is the number of pages, and the value is calculated using the formula below.
| Panel |
|---|
TEMP_MAX_PAGE_COUNT = Sum of maximum disk temporary tablespaces / 8192 |
| Tip |
|---|
Example of TEMP_MAX_PAGE_COUNT calculation If the total sum of the maximum disk temporary tablespaces is 17179869184 bytes (16GB), 17179869184/8192 = 2097152, and the value of the TEMP_MAX_PAGE_COUNT property is 2097152. TEMP_MAX_PAGE_COUNT setting value for each total maximum of disk temporary tablespaces TEMP_MAX_PAGE_COUNT = 1048576 for 8G TEMP_MAX_PAGE_COUNT = 2096128 for 16G TEMP_MAX_PAGE_COUNT = 4192256 for 32G TEMP_MAX_PAGE_COUNT = 8388608 for 64G |
...
| Code Block | ||
|---|---|---|
| ||
ALTER SYSTEM SET TEMP_MAX_PAGE_COUNT = value; |
Check V$PROPERTY to check the changed value.
| Code Block | ||
|---|---|---|
| ||
SELECT NAME, VALUE1 FROM V$PROPERTY WHERE NAME = 'TEMP_MAX_PAGE_COUNT'; |
Altibase server configuration file is also changed so that the value changed to ALTER SYSTEM is reflected even after restarting the Altibase server.
| Code Block | ||||
|---|---|---|---|---|
| ||||
shell> cd $ALTIBASE_HOME/conf shell> vi altibase.properties # If TEMP_MAX_PAGE_COUNT does not exist in the altibase.properties file, if it is added, the existing value is changed. TEMP_MAX_PAGE_COUNT = value; |
...
TOTAL_WA_SIZE = 1048576*256 = 268435456 (Unit is bytes)
SORT_AREA_SIZE = 1048576*2 = 2097152 (unit is byte)
HASH_AREA_SIZE = 1048576*8 = 8388608 (Unit is byte)
Like TEMP_MAX_PAGE_COUNT, the following three properties can be changed at the system level during Altibase operation.
| Code Block | ||
|---|---|---|
| ||
ALTER SYSTEM SET TOTAL_WA_SIZE = value; ALTER SYSTEM SET SORT_AREA_SIZE = value; ALTER SYSTEM SET HASH_AREA_SIZE = value; |
Check V$PROPERTY to check the changed value.
| Code Block | ||
|---|---|---|
| ||
SELECT NAME, VALUE1 FROM V$PROPERTY WHERE NAME IN ('TOTAL_WA_SIZE', 'SORT_AREA_SIZE', 'HASH_AREA_SIZE'); |
Altibase The altibase server configuration file is also changed so that the value changed to ALTER SYSTEM is reflected even after restarting the Altibase server.
| Code Block |
|---|
shell> cd $ALTIBASE_HOME/conf shell> vi altibase.properties # Find and change each property in the altibase.properties file. TOTAL_WA_SIZE = 134217728 # default = 134217728 SORT_AREA_SIZE = 1048576 # default = 1048576 HASH_AREA_SIZE = 4194304 # default = 4194304 |
...