--操作系统统计信息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.
操作系统统计信息v$osstat
最新推荐文章于 2021-12-03 00:10:09 发布