Dear experts,
As we know that db_block_size is a static parameter whereas db_cache_size is a dynamic parameter. so, is there any way through which we can change the static parameter to dynamic and dynamic parameter to static.
NAME
--------------------------------------------------------------------------------
ISSYS_MOD
---------
db_block_size
FALSE
SQL> select name, ISSYS_MODIFIABLE from v$parameter where name='db_cache_size';
NAME
--------------------------------------------------------------------------------
ISSYS_MOD
---------
db_cache_size
IMMEDIATE
Regards,
Raman
0