gs801->oracle$ps -mu oracle|wc
1079 3004 59043
gs801->oracle$ps -u oracle|wc
219 1280 12598
而在另外三台es40,和这台机器不一样
# ps -u oracle|wc
185 1087 10757
# ps -mu oracle|wc
189 1095 10973
我看了系统参数
gs80的为
proc:
max_proc_per_user = 2048
max_threads_per_user = 2048
per_proc_stack_size = 8388608
max_per_proc_stack_size = 33554432
per_proc_data_size = 134217728
max_per_proc_data_size = 1073741824
max_per_proc_address_space = 4294967296
per_proc_address_space = 4294967296
executable_stack = 0
autonice = 0
autonice_time = 600
autonice_penalty = 4
open_max_soft = 4096
open_max_hard = 4096
ncallout_alloc_size = 8192
round_robin_switch_rate = 0
sched_min_idle = 0
give_boost = 1
maxusers = 2048
num_wait_queues = 2048
num_timeout_hash_queues = 2048
enhanced_core_name = 0
enhanced_core_max_versions = 16
exec_disable_arg_limit = 0
dump_cores = 1
dump_setugid_cores = 0
executable_data = 0
ES40的为
# sysconfig -q proc
proc:
max_proc_per_user = 512
max_threads_per_user = 1024
per_proc_stack_size = 8388608
max_per_proc_stack_size = 33554432
per_proc_data_size = 134217728
max_per_proc_data_size = 1073741824
max_per_proc_address_space = 4294967296
per_proc_address_space = 4294967296
executable_stack = 0
autonice = 0
autonice_time = 600
autonice_penalty = 4
open_max_soft = 4096
open_max_hard = 4096
ncallout_alloc_size = 8192
round_robin_switch_rate = 0
sched_min_idle = 0
give_boost = 1
maxusers = 1024
num_wait_queues = 1024
num_timeout_hash_queues = 1024
enhanced_core_name = 0
enhanced_core_max_versions = 16
exec_disable_arg_limit = 0
dump_cores = 1
dump_setugid_cores = 0
executable_data = 0
请教各位,什么原因造成oracle每个进程生成多个线程呢,应用完全一样,数据库也是dedicated连接,与max_proc_per_user = 2048
max_threads_per_user = 2048这两个参数设置一样有关吗,我觉得不是,这些参数只是设定最大值,并不会造成多线程。也查了root用户的,公司GS80和ES40差不多,看看各位有何高招,或者思路,谢谢。
会员注册
会员登录
个人空间