Wednesday, May 9, 2012

How to find out cpu cores from within oracle???

SELECT
 MAX(DECODE(STAT_NAME,'NUM_CPUS',VALUE,1)) CPUS,
 MAX(DECODE(STAT_NAME,'NUM_CPU_CORES',VALUE,1)) CPU_CORES,
 max(decode(STAT_NAME,'PHYSICAL_MEMORY_BYTES',round(VALUE/1024/1204),1)) Memory_MB
FROM V$OSSTAT;

No comments:

Post a Comment