Re: does sga_target cause resizing of db_32k_cache_size

My error/
Confusing "dynamic" with "automatic".

Apologies
Jonathan Lewis

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

> 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>
>
>
>
>
>
>

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