TMP$POOLS

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.

TMP$POOLS

Column name	Datatype for <=ODS 15	Datatype for >=ODS 16, dialect 1	Datatype 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 (18, 0)	Total memory in pool
TMP$FREE_MEMORY	INTEGER	DOUBLE PRECISION	Numeric (18, 0)	Free memory in pool
TMP$EXTEND_MEMORY	INTEGER	DOUBLE PRECISION	Numeric (18, 0)	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