Thanks for the question, Peter.
Asked: April 28, 2017 - 6:09 am UTC
Last updated: April 29, 2017 - 1:37 am UTC
Version: 12.1.0.2
Viewed 1000+ times
You Asked
SQL>select component, user_specified_size, min_size, current_size
2 from v$sga_dynamic_components
3 where component = 'shared pool';
COMPONENT USER_SPECIFIED_SIZE MIN_SIZE CURRENT_SIZE
--------------- ------------------- ---------- ------------
shared pool 0 6106906624 6106906624
Min_Size = Current_Size = 6106906624
My database is currently using spfile.
How can I reset/reduce the MIN_SIZE without creating pfile and restarting the database.
Is the internal parameter used by database modifiable?
orcl.__shared_pool_size=6106906624
alter system set "__shared_pool_size"=3221225472;
Above command seems to modify the parameter "*.__shared_pool_size" instead of "orcl.__shared_pool_size".
and Connor said...
It's not modifiable, because it is the setting to be 'remembered' when the instance restarts. If you want to set a min size, just set the normal 'shared_pool_size' parameter - this sets a threshold on the size that the shared pool cannot fall below.
Is this answer out of date? If it is, please let us know via a Comment