Find cpu MHz in Oracle view [message #637292] |
Thu, 14 May 2015 07:50 |
Malakay79
Messages: 41 Registered: September 2007
|
Member |
|
|
I would like to know ig there is a way to get cpu MHz in oracle view.
I need to get from oracle this value:
processor : 1
vendor_id : GenuineIntel
cpu family : 6
model : 45
model name : Intel(R) Xeon(R) CPU E5-2665 0 @ 2.40GHz
stepping : 2
microcode : 1808
cpu MHz : 2400.000
cache size : 20480 KB
physical id : 0
siblings : 2
core id : 1
cpu cores : 2
apicid : 1
initial apicid : 1
fpu : yes
fpu_exception : yes
cpuid level : 13
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx rdtscp lm constant_tsc arch_perfmon pebs bts xtopology tsc_reliable nonstop_tsc aperfmperf unfair_spinlock pni pclmulqdq ssse3 cx16 sse4_1 sse4_2 popcnt aes xsave avx hypervisor lahf_lm ida arat epb pln pts dts
bogomips : 4800.00
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management:
[Updated on: Thu, 14 May 2015 07:50] Report message to a moderator
|
|
|
|
Re: Find cpu MHz in Oracle view [message #637295 is a reply to message #637294] |
Thu, 14 May 2015 08:01 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
1* SELECT * FROM sys.aux_stats$ WHERE UPPER(SNAME) LIKE '%CPU%' OR UPPER(PNAME) LIKE '%CPU%'
SQL> /
SNAME PNAME PVAL1
------------------------------ ------------------------------ ----------
PVAL2
--------------------------------------------------------------------------------
SYSSTATS_MAIN CPUSPEEDNW 2696.05568
SYSSTATS_MAIN CPUSPEED
|
|
|