RE: does sga_target cause resizing of db_32k_cache_size
Date: Thu, 11 Mar 2021 16:33:49 +0000
Message-ID: <DM6PR09MB46777DB3811CDEC3E928161DDF909_at_DM6PR09MB4677.namprd09.prod.outlook.com>
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
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
On Thu, 11 Mar 2021 at 15:49, Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org<mailto: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
Subject: Re: does sga_target cause resizing of db_32k_cache_size
Jonathan Lewis
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 11 2021 - 17:33:49 CET