操作系统统计信息v$osstat

--操作系统统计信息v$osstat如果无法访问数据库服务器，又想得到一些操作系统级别的核心性能指标，可以通过查询v$osstat动态性能视图得到。SYS@PROD1> select stat_name,value,comments from v$osstat;STAT_NAME      VALUE COMMENTS---------------------------------------------------------------- ---------- ----------------------------------------------------------------NUM_CPUS  1 Number of active CPUsIDLE_TIME    1860201 Time (centi-secs) that CPUs have been in the idle stateBUSY_TIME     110306 Time (centi-secs) that CPUs have been in the busy stateUSER_TIME       7445 Time (centi-secs) spent in user codeSYS_TIME      14114 Time (centi-secs) spent in the kernelIOWAIT_TIME      15846 Time (centi-secs) spent waiting for IONICE_TIME       6773 Time (centi-secs) spend in low-priority user codeRSRC_MGR_CPU_WAIT_TIME 73 Time (centi-secs) processes spent in the runnable state waitingLOAD  0 Number of processes running or waiting on the run queueNUM_CPU_CORES  1 Number of CPU coresNUM_CPU_SOCKETS   1 Number of physical CPU socketsPHYSICAL_MEMORY_BYTES 3207176192 Physical memory size in bytesVM_IN_BYTES  0 Bytes paged in due to virtual memory swappingVM_OUT_BYTES  0 Bytes paged out due to virtual memory swappingTCP_SEND_SIZE_MIN       4096 TCP Send Buffer Min SizeTCP_SEND_SIZE_DEFAULT      16384 TCP Send Buffer Default SizeTCP_SEND_SIZE_MAX    4194304 TCP Send Buffer Max SizeTCP_RECEIVE_SIZE_MIN       4096 TCP Receive Buffer Min SizeTCP_RECEIVE_SIZE_DEFAULT      87380 TCP Receive Buffer Default SizeTCP_RECEIVE_SIZE_MAX    4194304 TCP Receive Buffer Max SizeGLOBAL_SEND_SIZE_MAX    4194304 Global send size max (net.core.wmem_max)GLOBAL_RECEIVE_SIZE_MAX     4194304 Global receive size max (net.core.rmem_max)22 rows selected.