onstat -g mem command: Print pool memory statistics
Use the onstat -g mem command to display the memory statistics for a pool.
If you run an SQL query that allocates memory from the PER_STMT_EXEC and PER_STMT_PREP memory duration pools, the onstat -g mem command displays information about the PRP.sessionid.threadid pool and the EXE.sessionid.threadid pool.
Syntax:
onstat -gmem [ pool namesession id ]Session pools are named with the session number. If no argument is provided, information about all pools is displayed.
Example output
Output description
- Pool Summary
- name
- Pool name
- Shared memory segment type where the pool is created
- addr
- Pool memory address
- totalsize
- Pool size, in bytes
- freesize
- Free memory in pool
- #allocfrag
- Allocated fragments in pool
- #freefrag
- Free fragments in pool
- Blkpool Summary
- name
- Pool name
- Shared memory segment type where pool is created
- addr
- Pool memory address
- size
- Pool size, in bytes
- #blks
- Number of blocks in pool