Home » RDBMS Server » Performance Tuning » Find cpu MHz in Oracle view (Linux red hat 6.6, oracle 11.2.0.4 )
Find cpu MHz in Oracle view [message #637292] Thu, 14 May 2015 07:50 Go to next message
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 #637294 is a reply to message #637292] Thu, 14 May 2015 07:56 Go to previous messageGo to next message
John Watson
Messages: 7615
Registered: January 2010
Location: Global Village
Senior Member
You can look at the sys.aux_stats$ table, if you have gathered your system statistics.
Re: Find cpu MHz in Oracle view [message #637295 is a reply to message #637294] Thu, 14 May 2015 08:01 Go to previous message
BlackSwan
Messages: 26187
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
Previous Topic: ORACLE SQL PERFORMANCE TUNING AND OPTIMIZATION - Kevin Meade's book corner
Next Topic: Set NOLOGGING for tables in UAT
Goto Forum:
  


Current Time: Tue Oct 16 14:22:46 CDT 2018