DBA_HIST_OSSTAT


http://dbaspot.com/oracle-server/4910-find-out-how-many-cpus-print.html
NUM_CPUS returns the number of virtual
CPUs, including in the count hyperthreaded CPUs in addition to the
actual core count. NUM_CPU_CORES returns the number of actual CPU
cores reported by the operating system.

Operating System Statistics

StatisticTotal
NUM_LCPUS0
NUM_VCPUS0
AVG_BUSY_TIME24,697
AVG_IDLE_TIME53,739
AVG_IOWAIT_TIME26,402
AVG_SYS_TIME13,104
AVG_USER_TIME11,565
BUSY_TIME395,570
IDLE_TIME860,257
IOWAIT_TIME422,811
SYS_TIME210,061
USER_TIME185,509
LOAD0
OS_CPU_WAIT_TIME408,100
RSRC_MGR_CPU_WAIT_TIME0
PHYSICAL_MEMORY_BYTES51,539,607,552
NUM_CPUS16
NUM_CPU_CORES8


Comments