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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment