Oracle查询动、静态参数

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