System Temporary Tables
The InterBase server keeps a massive collection of information about its databases, connections, transactions, and statements. This information is made available through the following system temporary tables. For more information about using these tables, see the InterBase Operations Guide.
ODS-16: In System Temporary Tables, Performance Monitoring data counters are updated to 64-bit Integer type for dialect 3. Dialect 1 cannot support 64-bit Integer type, so a 64-bit Integer type is internally convered to type "double" as it is same in size (8 bytes). It also accommodates the large values for 64-bit addresses and counter values.
ODS 15 remains the same as before and only supports 32-bit Integer counters.
- ODS <= 15 will continue to have 32-bit INTEGER counters as before (for both dialect 1 and dialect 3 databases).
- ODS >= 16 will have the counters defined as "double precision" data type for dialect 1 databases.
- ODS >= 16 will have the counters defined as "NUMERIC(18,0)" data type for dialect 3 databases. As you know, by default, any new database is created as ODS 16, dialect 3.
Temporary table names begin with
TMP$. InterBase offers the following system temporary tables: