select name, to_number(value) value from v$parameter where name in ( 'parallel_min_servers', 'parallel_max_servers', 'cpu_count', 'cpu_min_count' ) union all select stat_name, value from v$osstat where stat_name in ( 'NUM_CPUS', 'NUM_CPU_CORES', 'NUM_CPU_SOCKETS' ) ;