Database Administration (MOSC)

MOSC Banner

How can I increase the memory used by Oracle 19c DB?

I Recently created a 19c Enterprise DB on a Windows server with 54GB of memory. I allocated 48GB to the DB. Today I increased the physical memory to 116GB. I would like to increase the memory utilization to 106GB.

When investigating the memory parameters I found the SGA_LIMIT and MEMORY_MAX_TARGET set to 0. pga_aggregate_target was set to 12205M. Following guidance from Oracle documentation i made the following changes;

alter system set memory_max_target = 104G scope=spfile;

restart the DB

alter system set SGA_TARGET = 0 scope=both;
alter system set PGA_AGGREGATE_TARGET = 0 scope=both;

Task manager showed the memory utilization at 41GB. So I ran a few queries with large sorts like;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center