Re: does sga_target cause resizing of db_32k_cache_size
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Thu, 11 Mar 2021 16:31:47 +0000
Message-ID: <CAGtsp8nncdG_QMOLEG--W=1KKF=MGX3c9VYA-5jDSpqq-BO9-Q_at_mail.gmail.com>
Date: Thu, 11 Mar 2021 16:31:47 +0000
Message-ID: <CAGtsp8nncdG_QMOLEG--W=1KKF=MGX3c9VYA-5jDSpqq-BO9-Q_at_mail.gmail.com>
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-lReceived on Thu Mar 11 2021 - 17:31:47 CET