TMP$ATTACHMENTS
From InterBase
Go Up to System Temporary Tables
The TMP$ATTACHMENTS table contains one row for each connection to a database.
| Column name | Data type for <=ODS 15 | Data type for >=ODS 16, dialect 1 | Data type for >=ODS 16, dialect 3 | Description |
|---|---|---|---|---|
TMP$ATTACHMENT_ID
|
INTEGER
|
Connection identifier | ||
TMP$DATABASE_ID
|
INTEGER
|
Database identifier | ||
TMP$POOL_ID
|
INTEGER
|
Reserved | ||
TMP$POOL_MEMORY
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Reserved |
TMP$STATEMENTS
|
SMALLINT
|
Number of compiled statements | ||
TMP$TRANSACTIONS
|
SMALLINT
|
Number of active transactions | ||
TMP$TIMESTAMP
|
TIMESTAMP
|
Connection create timestamp | ||
TMP$QUANTUM
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Units of execution |
TMP$USER
|
CHAR[67]
|
User name | ||
TMP$USER_IP_ADDR
|
CHAR [31]
|
User IP address | ||
TMP$USER_HOST
|
CHAR [31]
|
User host name | ||
TMP$USER_PROCESS
|
CHAR [31]
|
User process ID | ||
TMP$STATE
|
CHAR [31]
|
Current State: Allowed Update actions: | ||
TMP$PRIORITY
|
CHAR [31]
|
Reserved | ||
TMP$DBKEY_ID
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Transaction ID of dbkey |
TMP$ACTIVE_SORTS
|
SMALLINT
|
Number of active sorts | ||
TMP$PAGE_READS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Page reads all database files |
TMP$PAGE_WRITES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Page writes all database files |
TMP$PAGE_FETCHES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Page fetches all database files |
TMP$PAGE_MARKS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Page marks all database files |
TMP$RECORD_SELECTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Records selected by connection |
TMP$RECORD_INSERTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Records inserted by connection |
TMP$RECORD_UPDATES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Records updated by connection |
TMP$RECORD_DELETES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Records deleted by connection |
TMP$RECORD_PURGES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Garbage collect record purges |
TMP$RECORD_EXPUNGES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Garbage collect record expunges |
TMP$RECORD_BACKOUTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC (18, 0) | Garbage collect record backouts |