SQL> desc v$parameter;
Name Null? Type
----------------------------------------- -------- ----------------------------
NUM NUMBER
NAME VARCHAR2(80)
TYPE NUMBER
VALUE VARCHAR2(4000)
DISPLAY_VALUE VARCHAR2(4000)
ISDEFAULT VARCHAR2(9)
ISSES_MODIFIABLE VARCHAR2(5)
ISSYS_MODIFIABLE VARCHAR2(9)
ISINSTANCE_MODIFIABLE VARCHAR2(5)
ISMODIFIED VARCHAR2(10)
ISADJUSTED VARCHAR2(5)
ISDEPRECATED VARCHAR2(5)
ISBASIC VARCHAR2(5)
DESCRIPTION VARCHAR2(255)
UPDATE_COMMENT VARCHAR2(255)
HASH NUMBER
SQL> select distinct issys_modifiable from v$parameter;
ISSYS_MODIFIABLE
------------------
IMMEDIATE
FALSE
DEFERRED
IMMEDIATE 动态参数
FALSE 静态参数
DEFERRED LEVEL级别动态参数
SQL> select ISSYS_MODIFIABLE from v$parameter where name='log_archive_dest_state_1';
ISSYS_MODIFIABLE
------------------
IMMEDIATE