RE: does sga_target cause resizing of db_32k_cache_size

Thanks. Looks like I have to set and adjust the parameter manually rather than Oracle adjusting it.

From: Mikhail Velikikh <mvelikikh_at_gmail.com> Sent: Thursday, March 11, 2021 12:47 PM
To: Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org> Cc: Jonathan Lewis <jlewisoracle_at_gmail.com>; oracle-l_at_freelists.org Subject: 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<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.oracle.com%2Fen%2Fdatabase%2Foracle%2Foracle-database%2F19%2Fadmin%2Fmanaging-memory.html%23GUID-1B568DEC-AAC0-4626-B44C-A6D446077032__BABDCHDE&data=04%7C01%7Cjbeckstrom%40gcrta.org%7Cb30ef0188e644f599e4c08d8e4b5be71%7Cebe8e20736ec47f48cb8f5f757605f5d%7C1%7C0%7C637510816538354939%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=B8BnQ0V6lNW2TOuQ2qP3dQTRDG8pvNNW5shjeaQKFUM%3D&reserved=0> 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<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fdocs.oracle.com%2Fen%2Fdatabase%2Foracle%2Foracle-database%2F19%2Fadmin%2Fmanaging-memory.html%23GUID-1B568DEC-AAC0-4626-B44C-A6D446077032__BABBDEFJ&data=04%7C01%7Cjbeckstrom%40gcrta.org%7Cb30ef0188e644f599e4c08d8e4b5be71%7Cebe8e20736ec47f48cb8f5f757605f5d%7C1%7C0%7C637510816538354939%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=Ey0bTn6WOUrsRJDaOeVH5DC3Aby8yTK3pkJElLge6DM%3D&reserved=0>

On Thu, 11 Mar 2021 at 16:35, Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org<mailto: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<mailto:jlewisoracle_at_gmail.com>> Sent: Thursday, March 11, 2021 11:32 AM
To: Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org<mailto:jbeckstrom_at_gcrta.org>> Cc: oracle-l_at_freelists.org<mailto: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<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
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113

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