代码改变世界

v$osstat

  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与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 理解Rust引用及其生命周期标识(上)
· 浏览器原生「磁吸」效果!Anchor Positioning 锚点定位神器解析
阅读排行:
· DeepSeek 开源周回顾「GitHub 热点速览」
· 物流快递公司核心技术能力-地址解析分单基础技术分享
· .NET 10首个预览版发布:重大改进与新特性概览!
· AI与.NET技术实操系列(二):开始使用ML.NET
· .NET10 - 预览版1新功能体验(一)
点击右上角即可分享
微信分享提示