How can I increase the memory used by Oracle 19c DB?
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;