The type of memory pool.
Table 1. Snapshot
Monitoring InformationSnapshot Level |
Logical Data Grouping |
Monitor
Switch |
Database Manager |
memory_pool |
Basic |
Database |
memory_pool |
Basic |
Application |
memory_pool |
Basic |
Table 2. Event
Monitoring InformationEvent Type |
Logical Data Grouping |
Monitor
Switch |
Database |
event_dbmemuse |
- |
Connection |
event_connmemuse |
- |
Usage
To track system memory usage, use this value
in conjunction with pool_config_size, pool_cur_size,
and pool_watermark.
Use
pool_id to
identify the memory pools discussed in the system monitor output. The various
memory pool identifiers can be found in
sqlmon.h.
Under
normal operating conditions, one or more of each of the following
pools can
be expected.
API Constant |
Description |
SQLM_HEAP_APPLICATION |
Application Heap |
SQLM_HEAP_DATABASE |
Database
Heap |
SQLM_HEAP_LOCK_MGR |
Lock Manager Heap |
SQLM_HEAP_UTILITY |
Backup/Restore/Utility
Heap |
SQLM_HEAP_STATISTICS |
Statistics Heap |
SQLM_HEAP_PACKAGE_CACHE |
Package Cache Heap |
SQLM_HEAP_CAT_CACHE |
Catalog
Cache Heap |
SQLM_HEAP_MONITOR |
Database Monitor Heap |
SQLM_HEAP_STATEMENT |
Statement
Heap |
SQLM_HEAP_FCMBP |
FCMBP Heap |
SQLM_HEAP_IMPORT_POOL |
Import Pool |
SQLM_HEAP_OTHER |
Other Memory |
SQLM_HEAP_BP |
Buffer Pool Heap |
SQLM_HEAP_APPL_SHARED |
Applications
Shared Heap |
SQLM_HEAP_SHARED_SORT |
Sort Shared Heap |