The system table SYSINFO.MACHINEUTILIZATION contains information about the utilization of the computer on which the database is installed.
PHYSICALMEMORYUSABLE |
FIXED(10) |
Size of free physical memory (MB) |
VIRTUALMEMORYUSABLE |
FIXED(10) |
Size of free virtual memory (MB) |
PROCESSUSEDUSERTIME |
FIXED(10) |
Time the database kernel process has spent in user mode since the database was started (s) |
PROCESSUSEDSYSTEMTIME |
FIXED(10) |
Time the database kernel process has spent in system mode since the database was started (s) |
MACHINEUSEDUSERTIME |
FIXED(10) |
Time the computer has spent in user mode since it was started (s) |
MACHINEUSEDSYSTEMTIME |
FIXED(10) |
Time the computer has spent in system mode since it was started (s) |
MACHINEIDLETIME |
FIXED(10) |
Time the computer has spent in idle mode since it was started (s) |
MACHINEIOWAITTIME |
FIXED(10) |
Time the computer has waited for I/O since it was started (s) |
CPULOAD |
CHAR(12) |
CPU load on the computer |