The system table SYSINFO.MACHINECONFIGURATION contains information about the configuration of the computer on which the database is installed.
CPUNUMBER |
FIXED(5) |
Number of CPUs |
PHYSICALCPUNUMBER |
FIXED(5) |
Number of physically available CPU IDs assigned by the operating system |
PHYSICALMEMORYSIZE |
FIXED(10) |
Size of physical memory (MB) |
VIRTUALMEMORYSIZE |
FIXED(10) |
Size of virtual memory (MB) |