Re: does sga_target cause resizing of db_32k_cache_size

Take a look at:
1) Table 6-2 Automatically Sized SGA Components and Corresponding Parameters https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html#GUID-1B568DEC-AAC0-4626-B44C-A6D446077032__BABDCHDE 2) Table 6-3 Manually Sized SGA Components that Use SGA_TARGET Space https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/managing-memory.html#GUID-1B568DEC-AAC0-4626-B44C-A6D446077032__BABBDEFJ

On Thu, 11 Mar 2021 at 16:35, Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org> wrote:

> I had tried googling it and only db_cache_size was listed, not the various
> other sub pools. This is our first database with multiple pools. We will
> monitor it to see if it resizes.
>
>
>
> *From:* Jonathan Lewis <jlewisoracle_at_gmail.com>
> *Sent:* Thursday, March 11, 2021 11:32 AM
> *To:* Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org>
> *Cc:* oracle-l_at_freelists.org
> *Subject:* Re: does sga_target cause resizing of db_32k_cache_size
>
>
>
>
>
> 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_at_gcrta.org>
> 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
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l