The statistics system table USERSTATISTICS contains information about the resource consumption of users.
USERSTATISTICS
USERNAME |
CHAR(32) |
Name of the database user |
USERMODE |
CHAR(8) |
Database user class |
PERMCOUNT |
FIXED(10) |
Number of pages currently used for permanent objects |
TEMPCOUNT |
FIXED(10) |
Number of pages currently used for temporary objects |
See also:
Concepts of the Database System, Database Users