select name,value from v$parameter order by name;
select name,value from v$spparameter order by name;
parameter 显示当前在运行的实例中生效的参数值
spparameter 显示磁盘上spfile中存储的值
select name,value from v$spparameter order by name;
parameter 显示当前在运行的实例中生效的参数值
spparameter 显示磁盘上spfile中存储的值