How to change Oracles memory?

[sdrzewiczewski]

We're running 10g on Windows 64bit with 16gb of ram. I selected the largest database size from the installer, but it only utilizes 1gb of ram, I'd like to increase that to at least 2 possibly 4 gb. I also have the 10g tuner installed but i don't think this changes the initial memory allocation.

thanks

[JakobGlashuettn]

Hi,



maybe your sga_max_size is set to 1G or sga_target is too small



Start SQLPLUS and logon as user SYSTEM or SYS and execute the following
query.





SQL> show parameter sga_max_size;



NAME TYPE VALUE