查看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;--延迟，当前会话不生效，后续的会话有效

select name,value,ISSYS_MODIFIABLE from v$parameter order by name;