It's listed in v$sga_dynamic_components, which suggests that it can change
automatically; but you may find that it can only change if it's been set to
a non-zero value for instance startup
Regards
Jonathan Lewis
On Thu, 11 Mar 2021 at 15:49, Beckstrom, Jeffrey <jbeckstrom@xxxxxxxxx>
wrote:
Does Oracle resize db_32k_cache_size from its default value automatically
as needed or is db_32k_cache_size a manual setting only?
Jeffrey Beckstrom
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113