TMP$POOL BLOCKS

From InterBase

Go Up to System Temporary Tables


The TMP$POOL_BLOCKS table contains one row for each block of memory in each pool.

TMP$POOL_BLOCKS
Column name Data type for >=ODS 16, dialect 1 Data type for >=ODS 16, dialect 1 Data type for >=ODS 16, dialect 3 Description
TMP$POOL_ID INTEGER
TMP$ACC INTEGER
TMP$ARR INTEGER
TMP$ATT INTEGER
TMP$BCB INTEGER

Buffer control block

TMP$BDB INTEGER Buffer descriptor block
TMP$BLB INTEGER Blob block
TMP$BLF INTEGER
TMP$BMS INTEGER
TMP$BTB INTEGER
TMP$BTC INTEGER
TMP$CHARSET INTEGER
TMP$CSB INTEGER Compiler scratch block
TMP$CSCONVERT INTEGER
TMP$DBB INTEGER Database block
TMP$DCC INTEGER Data compression control block
TMP$DFW INTEGER Deferred work block
TMP$DLS INTEGER
TMP$EXT INTEGER
TMP$FIL INTEGER File block
TMP$FLD INTEGER
TMP$FMT INTEGER Format block
TMP$FRB INTEGER Free block
TMP$FUN INTEGER
TMP$HNK INTEGER Hunk block
TMP$IDB INTEGER
TMP$IDL INTEGER
TMP$IRB INTEGER
TMP$IRL INTEGER
TMP$LCK INTEGER Lock block
TMP$LWT INTEGER
TMP$MAP INTEGER
TMP$MFB INTEGER
TMP$NOD INTEGER Node block
TMP$OPT INTEGER
TMP$PRC INTEGER
TMP$PRE INTEGER Precedence block
TMP$PRM

INTEGER

TMP$REC INTEGER Record block
TMP$REL INTEGER Relation block
TMP$REQ INTEGER Request block
TMP$RIV INTEGER

TMP$RSB

INTEGER Record source block
TMP$RSC INTEGER
TMP$SAV INTEGER
TMP$SBM INTEGER Sparse bitmap block
TMP$SCL INTEGER
TMP$SDW INTEGER
TMP$SMB INTEGER

Sort map block

TMP$SRPB INTEGER
TMP$STR INTEGER String block
TMP$SVC INTEGER
TMP$SYM INTEGER
TMP$TEXTTYPE INTEGER
TMP$TFB INTEGER Temporary field block
TMP$TPC INTEGER
TMP$TRA INTEGER Transaction block
TMP$USR INTEGER
TMP$VCL INTEGER

Vector long block

TMP$VCT INTEGER
TMP$VCX INTEGER
TMP$XCP INTEGER

Advance To: