Problem Abstract: The unit for memory_pool_used and
memory_pool_used_hwm should be in KB
----------------------------------------------------------------
-------------------------------------------------
It's easy to reproduce the problem
Problem Desc:
-----------------
The values for memory_pool_used and memory_pool_used_hwm are not
shown in Kb:
Here are the steps to check the values:
1- Verify the database parameter - Locklist
Max storage for lock list (4KB) (LOCKLIST)
=AUTOMATIC(4120)
2- Run the command below to get the values:
SELECT coalesce(varchar(memory_set_type, 20),'total') AS
set_type, varchar(memory_pool_type,20) AS pool_type,
varchar(db_name, 20) AS db_name, APPLICATION_HANDLE,
memory_pool_used as "MEMORY_POOL_USED (kb)",
memory_pool_used_hwm as "MEMORY_POOL_USED_HWM(kb)" FROM
TABLE(MON_GET_MEMORY_POOL(NULL, CURRENT_SERVER, -2))
SET_TYPE POOL_TYPE DB_NAME
APPLICATION_HANDLE MEMORY_POOL_USED
(kb) MEMORY_POOL_USED_HWM(kb)
-------------------- -------------------- --------------------
-----------------------------------
----------------------------------------
-------------------------------------------------
DATABASE LOCK_MGR TESTE1 -
17498112 17498112
DATABASE DATABASE TESTE1 -
15335424 15335424
As the LOCKLIST value is 4120 pages of 4Kb the MEMORY_POOL_USED
AND MEMORY_POOL_USED_HWM should be 16480Kb (4120 * 4).
The result above shows 17498112 instead of 16480 |
