Memory Allocation in Oracle
Posted on 2011-03-01
My Oracle 11201 Logical datagurd (prd800d) database on IBM AIX plateform, initially had 16GB Memory and the Paging size was set to 20GB.
We had serious and frequent performance issues and consequently an additional 24GB of memory was added. We now have 40GB memory and the paging size is still at 20GB
Below is the out put from sho SGA command.
SQL> sho sga
Total System Global Area 1.2527E+10 bytes
Fixed Size 2218400 bytes
Variable Size 4798285408 bytes
Database Buffers 7717519360 bytes
Redo Buffers 8704000 bytes
Below is the info from the init.ora file.
prd200l is the Primary Database
prd800d is the Logical Dataguard.
prd200l.__oracle_base='/a0221/oracle'#ORACLE_BASE set from environment
prd800d.__oracle_base='/a0223/oracle'#ORACLE_BASE set from environment
My question is what parameters should I modify so that Oracle can take full advantage of the additional memory. Will that adjustment require a database bounce??