|
Blue Forest http://www.lslnet.com at 11:08 on July 18, 2006
Haar AIX5L 7.2 for connecting applications Increasingly, INSERT on slowing down? ? Urgent Please expert analysis :
Haar AIX5L 7.2 for connecting applications Increasingly, it slowed INSERT, not less complex applications linking the original, only to re - variable parameter change is faster, has increased the number of connecting Slow Down? ? Urgent
Sheapthres=20000 configuration parameters :
Maxagents=400
Num_poolagent=-1
Maxappls=150
Avg_appls=1
Dft_degree=-1
Catalogcache_sz=64
Logbufsz=128 buffpage=20000 sortheap=5000 stmtheap=4096
Chngpgs_thresh=60 num_iocleaners=8 num_ioservers=12
Maxfilop=64
Dbheap=22000 |
Haar AIX5L 7.2 for connecting applications Increasingly, INSERT on slowing down? ? Urgent Buffpage=20000? ? ?
Whether small 147,000? |
Haar AIX5L 7.2 for connecting applications Increasingly, INSERT on slowing down? ? Urgent How many physical memory you have in your AIX, how many connection when you have to insert start slow? |
| |