General

Long Description:

Our database server has 384 Gb of memory. The default installation of Oracle

seems to take around 60% of memory when Oracle starts up. In our case this

is about 240 Gb of memory. I assume Windows should still operate well if

Oracle was consuming 350 Gb of memory. How can we permanently change the

Oracle config to start up with approximately 350 Gb of physical memory

consumed? Is there any reason not to pursue this?

-----Original Message-----

From: FISrelius<cfs.administrator@sgrelius.com>

Sent: Friday, October 4, 2019 4:56 PM

To: Alan Reagan <Alan.Reagan@warrenaverett.com>

Subject: Information about Incident 2081349

**EXTERNAL EMAIL**

I wouldn't recommend jumping all the way to 350gb at first. Try 275gb and

then maybe 300gb if that is running fine and so forth.

If 11.2.0.4, run these as the SYS user:

create pfile from spfile;

alter system set sga_max_size=1024M scope=spfile;

alter system set sga_target=1024M scope=spfile;

alter system setmemory_max_target=1024M scope=spfile;

shutdown immediate;

startup

If 11.2.0.1, run these:

create pfile from spfile;

alter system setmemory_max_target=1024M scope=spfile;

alter system setmemory_target=1024M scope=spfile;

shutdown immediate;

startup

Note that the amount of RAM needs to be adjusted, as the examples I gave are

for setting the database to 1 GB of usage, not practical in real life.

----------------------------------------------------------------------------------------------------------------------

if you were going to move to 275Gb, it would be:

alter system set sga_max_size= 281600M scope=spfile;

alter system set sga_target= 281600M scope=spfile;

alter system setmemory_max_target= 281600M scope=spfile;