ebs越来越慢

knighta

smallnavy 发表于 2012-4-18 12:34
整理掉一些历史和过程数据。对表进行分析。

对表做分析这个做过

但是历史数据怎么整理哈？

wing hong

just from the stat showed above, looks both CPU and memory is not enough .
so either increase the supply ( cpu /memory) or reduce ur demand ( concurrent manager etc etc )

knighta

wing hong 发表于 2012-4-18 12:50
just from the stat showed above, looks both CPU and memory is not enough .
so either increase the  ...

cpu是没办法加了哈

内存在问dell能不能加

concurrent manger设置也有很大关关系么

wing hong

sort of . for example, you can balance the back ground job ( concurrent manager) and the front end ( form , web ) .

if ur machine is old/slow, then u can reduce the number of concurrent manager, therefore , the background job might take longer to execute, but at least the memory won't get swap out /paging etc.

knighta

wing hong 发表于 2012-4-18 13:59
sort of . for example, you can balance the back ground job ( concurrent manager) and the front end ( ...

concurrent 原来设置为10， 但老是pending，我就改成了20
是因为这个缘故导致系统越来越慢么

wing hong

that's quite likely. as said. u need to balance.

xxzhaobb

从TOP的信息里面看。CPU和内存好像都用的厉害。

erplabour

状况不够清楚: 1. 没用户访问这样?
                     2. 用户只查询也这样?
                     3. 运行报表后？
             4. 访问定制化程序后?
                      5. 用户都访问后?
              6. 每天还是偶尔?

knighta

erplabour 发表于 2012-4-18 16:05
状况不够清楚: 1. 没用户访问这样?
                     2. 用户只查询也这样?
                     3. ...

top - 17:04:59 up 52 days,  7:14,  4 users,  load average: 3.79, 3.15, 2.70
Tasks: 476 total,   7 running, 469 sleeping,   0 stopped,   0 zombie
Cpu(s): 27.3% us, 24.4% sy,  8.6% ni, 14.7% id, 25.0% wa,  0.0% hi,  0.0% si
Mem:   8310552k total,  8293300k used,    17252k free,     3956k buffers
Swap:  2097144k total,   963384k used,  1133760k free,  5046896k cached

现在CPU还好，但是mem还是还好，我已经调整了concurrent

cod4

把这个的结果拿来看看
ll $IAS_ORACLE_HOME/Apache/Jserv/logs/jvm