操作系统统计信息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 CPUs
IDLE_TIME							    1860201 Time (centi-secs) that CPUs have been in the idle state
BUSY_TIME							     110306 Time (centi-secs) that CPUs have been in the busy state
USER_TIME							       7445 Time (centi-secs) spent in user code
SYS_TIME							      14114 Time (centi-secs) spent in the kernel
IOWAIT_TIME							      15846 Time (centi-secs) spent waiting for IO
NICE_TIME							       6773 Time (centi-secs) spend in low-priority user code
RSRC_MGR_CPU_WAIT_TIME							 73 Time (centi-secs) processes spent in the runnable state waiting
LOAD									  0 Number of processes running or waiting on the run queue
NUM_CPU_CORES								  1 Number of CPU cores
NUM_CPU_SOCKETS 							  1 Number of physical CPU sockets
PHYSICAL_MEMORY_BYTES						 3207176192 Physical memory size in bytes
VM_IN_BYTES								  0 Bytes paged in due to virtual memory swapping
VM_OUT_BYTES								  0 Bytes paged out due to virtual memory swapping
TCP_SEND_SIZE_MIN						       4096 TCP Send Buffer Min Size
TCP_SEND_SIZE_DEFAULT						      16384 TCP Send Buffer Default Size
TCP_SEND_SIZE_MAX						    4194304 TCP Send Buffer Max Size
TCP_RECEIVE_SIZE_MIN						       4096 TCP Receive Buffer Min Size
TCP_RECEIVE_SIZE_DEFAULT					      87380 TCP Receive Buffer Default Size
TCP_RECEIVE_SIZE_MAX						    4194304 TCP Receive Buffer Max Size
GLOBAL_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.