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;
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