How To Find Whether The Parameter Is Static or Dynamic?
ISSYS_MODIFIABLE column display the values FALSE and IMMEDIATE.
FALSE: it means database bounce is require.
IMMEDIATE: it means database bounce not require.
Example:
SQL> select ISSYS_MODIFIABLE from v$parameter where name like '%control_files%';
ISSYS_MOD
---------
FALSE
SQL> select ISSYS_MODIFIABLE from v$parameter where name like '%open_cursors%';
ISSYS_MOD
---------
IMMEDIATE
SQL> select ISSYS_MODIFIABLE from v$parameter where name like '%undo_tablespace%';
ISSYS_MOD
---------
IMMEDIATE
SQL> select ISSYS_MODIFIABLE from v$parameter where name like '%log_archive_dest%';
ISSYS_MOD
---------
IMMEDIATE
No comments:
Post a Comment