Search notes:

Oracle: Init parameters PARALLEL_MIN_SERVERS and PARALLEL_MAX_SERVERS

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

See also

init parameters

Index