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