Oracle: Add more memory for SGA and PGA

- 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

Popular posts from this blog

Microsoft Word: Make picture background to be transparent

LINE: Change the contact name

Microsoft Visio: How to set default font