友善交流技术...
ORALCE参数设置
上一篇 /
下一篇 2010-01-05 15:47:00
/ 个人分类:Oracle数据库
oracle参数 | 并发用户 |
参数名称 | 开发/测试实例 | 11-100用户 | 101-500用户 | 501-1000用户 | 1001-2000用户 |
Processes | 200 | 200 | 800 | 1200 | 2500 |
Sessions | 400 | 400 | 1600 | 2400 | 5000 |
db_block_buffers | 20000 | 50000 | 150000 | 250000 | 400000 |
db_cache_size | 156M | 400M | 1G | 2G | 3G |
sga_target | 1G | 1G | 2G | 3G | 14G |
undo_retention | 1800 | 3600 | 7200 | 10800 | 14000 |
shared_pool_size (csp) | N/A | N/A | N/A | 1800M | 3000M |
shared_pool_reserved_size(csp) | N/A | N/A | N/A | 180M | 300M |
shared_pool_size(no csp) | 400M | 600M | 800M | 1000M | 2000M |
shared_pool_reserved_size(no csp) | 40M | 60M | 80M | 100M | 100M |
pga_aggregate_target | 1G | 2G | 4G | 10G | 20G |
Total_Memory required | ~2GB | ~3GB | ~6GB | !13GB | ~25GB |
收藏
举报
TAG: