v$osstat
2015-11-04 13:27 abce 阅读(686) 评论(0) 编辑 收藏 举报SQL> select * from v$osstat; STAT_NAME VALUE OSSTAT_ID COMMENTS CUM ---------------------------------------- ---------- ---------- ---------------------------------------------------------------- --- NUM_CPUS 40 0 Number of active CPUs NO IDLE_TIME 6.5569E+10 1 Time (centi-secs) that CPUs have been in the idle state YES BUSY_TIME 381611751 2 Time (centi-secs) that CPUs have been in the busy state YES USER_TIME 256753313 3 Time (centi-secs) spent in user code YES SYS_TIME 123624519 4 Time (centi-secs) spent in the kernel YES IOWAIT_TIME 23786444 5 Time (centi-secs) spent waiting for IO YES NICE_TIME 10088 6 Time (centi-secs) spend in low-priority user code YES RSRC_MGR_CPU_WAIT_TIME 59 14 Time (centi-secs) processes spent in the runnable state waiting YES LOAD .059570313 15 Number of processes running or waiting on the run queue NO NUM_CPU_CORES 20 16 Number of CPU cores NO NUM_CPU_SOCKETS 2 17 Number of physical CPU sockets NO PHYSICAL_MEMORY_BYTES 1.0142E+11 1008 Physical memory size in bytes NO VM_IN_BYTES 0 1009 Bytes paged in due to virtual memory swapping YES VM_OUT_BYTES 0 1010 Bytes paged out due to virtual memory swapping YES TCP_SEND_SIZE_MIN 4096 2000 TCP Send Buffer Min Size NO TCP_SEND_SIZE_DEFAULT 16384 2001 TCP Send Buffer Default Size NO TCP_SEND_SIZE_MAX 4194304 2002 TCP Send Buffer Max Size NO TCP_RECEIVE_SIZE_MIN 4096 2003 TCP Receive Buffer Min Size NO TCP_RECEIVE_SIZE_DEFAULT 87380 2004 TCP Receive Buffer Default Size NO TCP_RECEIVE_SIZE_MAX 4194304 2005 TCP Receive Buffer Max Size NO GLOBAL_SEND_SIZE_MAX 1048576 2006 Global send size max (net.core.wmem_max) NO GLOBAL_RECEIVE_SIZE_MAX 4194304 2007 Global receive size max (net.core.rmem_max) NO 22 rows selected. SQL>
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· .NET10 - 预览版1新功能体验(一)