Tuesday 26 February 2013

How to find whether parameter is static or dynamic?


ISSYS_MODIFIABLE column display value FALSE its mean that db bounce is require.if it
is IMMEDIATE then database bounce not require.


IMMEDIATE: database bounce not require.
FALSE:  database bounce require.
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