cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

How to change Oracles memory?

Highlighted

How to change Oracles memory?

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

1 REPLY 1

AW: How to change Oracles memory?

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
Announcements
LiveWorx Call For Papers Happening Now!