Thanks. Looks like I have to set and adjust the parameter manually rather than
Oracle adjusting it.
From: Mikhail Velikikh <mvelikikh@xxxxxxxxx>
Sent: Thursday, March 11, 2021 12:47 PM
To: Beckstrom, Jeffrey <jbeckstrom@xxxxxxxxx>
Cc: Jonathan Lewis <jlewisoracle@xxxxxxxxx>; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx<mailto:jbeckstrom@xxxxxxxxx>> 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@xxxxxxxxx<mailto:jlewisoracle@xxxxxxxxx>>
Sent: Thursday, March 11, 2021 11:32 AM
To: Beckstrom, Jeffrey <jbeckstrom@xxxxxxxxx<mailto:jbeckstrom@xxxxxxxxx>>
Cc: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx<mailto: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
