代码改变世界

v$osstat

2015-11-04 13:27  abce  阅读(722)  评论(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>