memory configuration - liamlamth/blog GitHub Wiki

total memory: 503G
sga_max_size                         big integer 260G
sga_min_size                         big integer 0
sga_target                           big integer 100G
pga_aggregate_limit                  big integer 440G
pga_aggregate_target                 big integer 55G
db_cache_size                        big integer 0
java_pool_size                       big integer 0
large_pool_size                      big integer 0
shared_pool_size                     big integer 0
streams_pool_size                    big integer 0
total memory: 251G
sga_max_size                         big integer 200G
sga_min_size                         big integer 0
sga_target                           big integer 0
pga_aggregate_limit                  big integer 200G
pga_aggregate_target                 big integer 38G
db_cache_size                        big integer 0
java_pool_size                       big integer 0
large_pool_size                      big integer 0
shared_pool_size                     big integer 0
streams_pool_size                    big integer 0
total memory: 125G
sga_max_size                         big integer 96G
sga_min_size                         big integer 0
sga_target                           big integer 0
pga_aggregate_limit                  big integer 96G
pga_aggregate_target                 big integer 0
db_cache_size                        big integer 0
java_pool_size                       big integer 0
large_pool_size                      big integer 0
shared_pool_size                     big integer 0
streams_pool_size                    big integer 0
⚠️ **GitHub.com Fallback** ⚠️