这个进程是数据库的并发服务进程,常会发现数据库服务器数量越多,并发服务进程就越多。和这个进程相关的参数有四个,oracle12c中,受限四个参数
cpu_count
parallel_threads_per_cpu
parallel_max_servers
parallel_min_servers
具体参看:
SQL>show parameter para
NAME
----------------------------------------------- ------------------------------
cell_offload_parameters
fast_start_parallel_rollback
parallel_adaptive_multi_user
parallel_automatic_tuning
parallel_degree_level
parallel_degree_limit
parallel_degree_policy
parallel_execution_message_size
parallel_force_local
parallel_instance_group
parallel_io_cap_enabled
NAME
----------------------------------------------- ------------------------------
parallel_max_servers
parallel_min_percent
parallel_min_servers
parallel_min_time_threshold
parallel_server
parallel_server_instances
parallel_servers_target
parallel_threads_per_cpu
recovery_parallelism
SQL>show parameter cpu
NAME
----------------------------------------------- ------------------------------
cpu_count
parallel_threads_per_cpu
resource_manager_cpu_allocation