oracle数据库的ora_p进程为什么这么多?
这个进程是数据库的并发服务进程,常会发现数据库服务器数量越多,并发服务进程就越多。和这个进程相关的参数有五个,oracle12c中,初始化参数的数量受限前四个参数
1.cpu_count cpu数量
2parallel_threads_per_cpu 默认一般是2
3。parallel_max_servers 默认值 PARALLEL_THREADS_PER_CPU *CPU_COUNT * concurrent_parallel_users * 5
4.parallel_min_servers 默认值 PARALLEL_THREADS_PER_CPU *CPU_COUNT * concurrent_parallel_users * 2
5.concurrent_parallel_users 这个参数随实际应用的用户多少变化
数据库启动的时候,初始化的并发服务进程数就是parallel_min_servers ,最大不超过parallel_max_servers(还有个限制就是3600)
具体参看:
SQL>show parameter para
NAME TYPE VALUE
----------------------------------------------- ------------------------------
cell_offload_parameters string
fast_start_parallel_rollback string LOW
parallel_adaptive_multi_user boolean TRUE
parallel_automatic_tuning boolean FALSE
parallel_degree_level integer 100
parallel_degree_limit string CPU
parallel_degree_policy string MANUAL
parallel_execution_message_size integer 16384
parallel_force_local boolean FALSE
parallel_instance_group string
parallel_io_cap_enabled boolean FALSE
NAME TYPE VALUE
----------------------------------------------- ------------------------------
parallel_max_servers integer 221
parallel_min_percent integer 0
parallel_min_servers integer 64
parallel_min_time_threshold string AUTO
parallel_server boolean FALSE
parallel_server_instances integer 1
parallel_servers_target integer 256
parallel_threads_per_cpu integer 2
recovery_parallelism integer 0
SQL>show parameter cpu
NAME TYPE VALUE
----------------------------------------------- ------------------------------
cpu_count integer 16
parallel_threads_per_cpu integer 2
resource_manager_cpu_allocation integer 16
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24179204/viewspace-2127053/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24179204/viewspace-2127053/