TMP$POOLS
From InterBase
Go Up to System Temporary Tables
The TMP$POOLS table contains one row for each current memory pool. A pool is a collection of memory to support the allocation needs of an internal system object.
| Column name | Data type for <=ODS 15 | Data type for >=ODS 16, dialect 1 | Data type for >=ODS 16, dialect 3 | Description |
|---|---|---|---|---|
TMP$POOL_ID
|
INTEGER
|
Pool identifier | ||
TMP$TYPE
|
CHAR[31]
|
Pool type | ||
TMP$POOL_MEMORY
|
INTEGER
|
DOUBLE PRECISION | Numeric
|
Total memory in pool |
TMP$FREE_MEMORY
|
INTEGER
|
DOUBLE PRECISION | Numeric
|
Free memory in pool |
TMP$EXTEND_MEMORY
|
INTEGER
|
DOUBLE PRECISION | Numeric
|
Memory by which pool extended |
TMP$FREE_STACK_NODES
|
SMALLINT
|
Free linked list stack nodes | ||
TMP$FREE_BITMAP_BUCKETS
|
SMALLINT
|
Free bitmap buckets | ||
TMP$FREE_BITMAP_SEGMENTS
|
INTEGER
|
Free bitmap segments |