Oracle: Add more memory for SGA and PGA
Environment : - Oracle 10g - Windows Server x64 By the default, when create database, can specify SGA and PGA not more than 2 GB (I tried at 3 GB and it's OK). To increase more, need to modify in Server Parameter File (spfile) which locate in folder '%ORACLE_HOME%\admin\ \pfile\init.ora.*'. Modify these parameters: - sga_target - pga_aggregate_target