查看oracle参数是静态或者是动态
select name,value,ISSYS_MODIFIABLE from v$parameter where ISSYS_MODIFIABLE =‘IMMEDIATE’ order by name ;–动态参数
select name,value,ISSYS_MODIFIABLE from v$parameter where ISSYS_MODIFIABLE =‘FALSE’ order by name ; ----静态参数,需要重启数据库参数才有效
select name,value,ISSYS_MODIFIABLE from v$parameter where ISSYS_MODIFIABLE =‘DERERRED’ order by name ;–延迟,当前会话不生效,后续的会话有效