Chapter 16. Growing the Oracle SGA to 2.7/3.42 GB in x86 Red Hat Enterprise Linux 3, 4 and 5 Without VLM58# cat /proc/3035/maps | grep SYSV50000000-aa200000 rw-s 00000000 00:04 262144 /SYSV8b1d1510 (deleted)#The following commands were executed on a 10g R2 database system:# ps -ef | grep "[o]ra_ckpt"oracle 4998 1 0 22:29 ? 00:00:00 ora_ckpt_orcl# cat /proc/4998/maps | grep SYSV20000000-f4200000 rw-s 00000000 00:04 4390912 /SYSV950d1f70 (deleted)#The output shows that the SGA attach address in 10g R2 is already lowered to 0x20000000 vs.0x50000000 in 10g R1. This means that Oracle 10g R2 does not have to be relinked for creatinglarger SGAs. For 10g R1 the SGA attach address must be lowered from 0x50000000 to e.g.0xe000000. You could also set it a little bit higher like 0x20000000 as its done by default in 10gRelease 2.The following example shows how to lower the SGA attach address to 0xe000000 in 10g R1 (see alsoMetalink Note:329378.1):su - oraclecd $ORACLE_HOME/rdbms/lib[[ ! -f ksms.s_orig ]] && cp ksms.s ksms.s_origgenksms -s 0Xe000000 > ksms.smake -f ins_rdbms.mk ksms.omake -f ins_rdbms.mk ioracleFor a detailed description of these commands, see Lowering the SGA Attach Address for SharedMemory Segments in Oracle 9i.You can verify the new lowered SGA attach address by running the following command:$ objdump -t $ORACLE_HOME/bin/oracle |grep sgabeg0e000000 l *ABS* 00000000 sgabeg$Now when 10g R1 is restarted the SGA attach address should be at 0xe000000:# ps -ef | grep "[o]ra_ckpt"oracle 4998 1 0 22:29 ? 00:00:00 ora_ckpt_orcl# cat /proc/4998/maps | grep SYSV0e000000-c1200000 rw-s 00000000 00:04 0 /SYSV8b1d1510 (deleted)#Now you should be able to create larger SGAs.NoteIf you increase the size of the SGA, essentially using more process address space forthe SGA, then less address space will be available for PGA memory. This means that ifyour application uses a lot of PGA memory, PGA allocations could fail even if you havesufficient RAM. In this case, you need to set the SGA attach address to a higher valuewhich will lower the SGA size.
