parser library‎ > ‎

system

Information about the system the database is running on. Initially the information comes from vmstat, some of it will be overrided with values from onstat -g osi, when available.

 column util description

 sys_usr vmstat 1 1 server cpu utilitzation
 sys_sys vmstat 1 1 server cpu utilitzation
 sys_wio vmstat 1 1 server cpu utilitzation
 sys_idle vmstat 1 1 server cpu utilitzation
 sys_mem_total_kb vmstat 1 1 total memory on server
 sys_mem_used_kb vmstat 1 1 memory used
 sys_mem_free_kb vmstat 1 1 memory free
 sys_servertime localtime time on the host
 sys_uptime uptime how long since server boot
 sys_hostip env only available from the web server, address of host
 sys_hostname hostname the name of the server
 sys_software env only available from the web server, web server software id

onstat -g osi

Operating system information supplied by the database engine.

 column description

 sys_os_name name of host operating system
 sys_os_release major version of operating system
 sys_os_node_name network name of the host
 sys_os_version version of the operating system
 sys_os_machine hardware type of host
 sys_number_of_processors number of processors in host
 sys_number_of_online_processors number of processors that are currently online
 sys_system_memory_page_size operating system page size
 sys_system_memory amount of core memory
 sys_system_free_memory amount of core memory available
 sys_number_of_open_files_per_process number of files allowed open per process
  
 sys_shmmax shared memory parameters
 sys_shmmin shared memory parameters 
 sys_shmids shared memory parameters 
 sys_shmnumsegs shared memory parameters 
  
 sys_semmap shared memory parameters
 sys_semids shared memory parameters 
 sys_semnum shared memory parameters 
 sys_semundo shared memory parameters 
 sys_semnumperid shared memory parameters 
 sys_semops shared memory parameters 
 sys_semundoperproc shared memory parameters 
 sys_semundosize shared memory parameters 
 sys_semmaxvalue shared memory parameters