The ADMIN_GET_MEM_USAGE table function gets the total memory consumption for a given instance.
>>-ADMIN_GET_MEM_USAGE--(--+--------+--)----------------------->< '-member-'
The schema is SYSPROC.
None
Column Name | Data type | Description |
---|---|---|
MEMBER | SMALLINT | member - Database member monitor element |
MAX_MEMBER_MEM | BIGINT | The maximum amount of memory (in bytes) available for the member. |
CURRENT_MEMBER_MEM | BIGINT | The amount of memory (in bytes) currently used by the member. |
PEAK_MEMBER_MEM | BIGINT | The peak or high watermark of memory (in bytes) used by the member since the instance started. |
Example 1: Report memory usage for all members
SELECT MEMBER, MAX_MEMBER_MEM, CURRENT_MEMBER_MEM, PEAK_MEMBER_MEM
FROM TABLE(SYSPROC.ADMIN_GET_MEM_USAGE()) AS T
MEMBER MAX_MEMBER_MEM CURRENT_MEMBER_MEM PEAK_MEMBER_MEM
------ -------------------- -------------------- --------------------
0 7430103040 958169088 958300160
3 7430103040 951615488 951615488
1 7430103040 952664064 952664064
2 7430103040 951615488 951615488
4 record(s) selected.