Static and dynamic parameter issue — oracle-mosc

Database Administration (MOSC)

MOSC Banner

Static and dynamic parameter issue

edited Dec 11, 2012 11:15PM in Database Administration (MOSC) 3 commentsAnswered

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.  

SQL> select name, ISSYS_MODIFIABLE from v$parameter where name='db_block_size';


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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center