MACHINEUTILIZATION

Definition

The system table MACHINEUTILIZATION contains information about the utilization of the computer on which the database kernel is installed.

Structure

MACHINEUTILIZATION

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 instance was started (s)

PROCESSUSEDSYSTEMTIME

FIXED(10)

Time the database kernel process has spent in system mode since the database instance was started (s)

MACHINEUSEDUSERTIME

FIXED(10)

Time the computer has spent in user mode since the database instance was started (s)

MACHINEUSEDSYSTEMTIME

FIXED(10)

Time the computer has spent in system mode since the database instance was started (s)

MACHINEUSEDIDLETIME

FIXED(10)

Time the computer has spent in idle mode since the database instance was started (s)

CPULOAD

CHAR(12)

CPU load on the computer