小白在日常工作中经常遇到数据库启动报错,其中80%都是跟数据库的初始化内存参数有关,现整理一份模板,以期后用
1. 查出linux服务器总的内存:8G左右
integer memTotalSize=`grep '^MemTotal:' /proc/meminfo | awk '{print $2}'` 8064956
((memTotalSize=memTotalSize*1024)) 8258514944
2. 将总内存的0.6分配给数据库oracle实例wsj
integer oraMemTotalSize=0
((oraMemTotalSize=memTotalSize*ora_memory)) 8258514944*0.6==4955108966
3. 将实例wsj的内存的0.6分配给最大内存
integer memoryMaxSize=0
((memoryMaxSize=oraMemTotalSize*0.6)) 4955108966*0.6==2973065379
*.memory_max_target=2973065379
4. 将实例总内存的0.5分配给内存大小
integer memorySize=0
((memorySize=oraMemTotalSize*0.5)) 4955108966*0.5==2477554483
*.memory_target=2477554483
5. 将实例总内存的0.4分配至sga内存
integer sgaSize=0
((sgaSize=oraMemTotalSize*0.4)) 4955108966*0.4==1982043586
*.sga_target=1982043586
6. 将实例总内存的0.1分配至pga内存
integer pgaSize=0
((pgaSize=oraMemTotalSize*0.1)) 4955108966*0.1==495510896
*.pga_aggregate_target=495510896
7. 将实例总内存的0.05分配给共享池
integer sharedPoolSize=0
((sharedPoolSize=oraMemTotalSize*0.05)) 955108966*0.05==247755448
*.shared_pool_size=247755448