SQL> select * from v$osstat; STAT_NAME VALUE OSSTAT_ID COMMENTS CUM
---------------------------------------- ---------- ---------- ---------------------------------------------------------------- ---
NUM_CPUS Number of active CPUs NO
IDLE_TIME 6.5569E+10 Time (centi-secs) that CPUs have been in the idle state YES
BUSY_TIME Time (centi-secs) that CPUs have been in the busy state YES
USER_TIME Time (centi-secs) spent in user code YES
SYS_TIME Time (centi-secs) spent in the kernel YES
IOWAIT_TIME Time (centi-secs) spent waiting for IO YES
NICE_TIME Time (centi-secs) spend in low-priority user code YES
RSRC_MGR_CPU_WAIT_TIME Time (centi-secs) processes spent in the runnable state waiting YES
LOAD . Number of processes running or waiting on the run queue NO
NUM_CPU_CORES Number of CPU cores NO
NUM_CPU_SOCKETS Number of physical CPU sockets NO
PHYSICAL_MEMORY_BYTES 1.0142E+11 Physical memory size in bytes NO
VM_IN_BYTES Bytes paged in due to virtual memory swapping YES
VM_OUT_BYTES Bytes paged out due to virtual memory swapping YES
TCP_SEND_SIZE_MIN TCP Send Buffer Min Size NO
TCP_SEND_SIZE_DEFAULT TCP Send Buffer Default Size NO
TCP_SEND_SIZE_MAX TCP Send Buffer Max Size NO
TCP_RECEIVE_SIZE_MIN TCP Receive Buffer Min Size NO
TCP_RECEIVE_SIZE_DEFAULT TCP Receive Buffer Default Size NO
TCP_RECEIVE_SIZE_MAX TCP Receive Buffer Max Size NO
GLOBAL_SEND_SIZE_MAX Global send size max (net.core.wmem_max) NO
GLOBAL_RECEIVE_SIZE_MAX Global receive size max (net.core.rmem_max) NO rows selected. SQL>