Marcel,
mir geht es um die folgenden Informationen aus den temporary system tables (in
IB 7.1 bzw. 7.5):
TMP$ATTACHMENTS Zeigt alle Connections zu einer Datenbank an
TMP$DATABASE Zeigt alle verbundenen Datenbanken an
TMP$POOL_BLOCKS Zeigt alle each block of memory in each pool
TMP$POOLS
TMP$PROCEDURES each procedure executed since the current connection began
TMP$RELATIONS each relation referenced since the current connection began
TMP$STATEMENTS each statement currently executing for any current connection
TMP$TRANSACTIONS each transaction that is active or in limbo
TMP$HEAPS
TMP$TRIGGERS
thomas