SELECT
      STAT_NAME,
      DECODE(STAT_NAME,'PHYSICAL_MEMORY_BYTES',(ROUND(VALUE/1024/1024/1024,2))
      || ' GB','FREE_MEMORY_BYTES',(ROUND(VALUE /1024/1024/1024,2))
      || ' GB',VALUE ) VALUE
    FROM
      v$osstat
    WHERE
     stat_name IN ( 'FREE_MEMORY_BYTES', 'LOAD', 'NUM_CPUS', 'NUM_CPU_CORES', 'NUM_CPU_SOCKETS', 'PHYSICAL_MEMORY_BYTES' );