Question: can sga_target be set dynamically?
Answer: The Oracle sga_max_size parameter sets the hard limit up to which sga_target can dynamically adjust sizes. ... By setting the Oracle sga_max_size parameter higher than sga_target, you allow dynamic adjustment of the sga_target parameter.