如何查看Oracle数据库的parameter

2014-11-24 18:58:00 · 作者: · 浏览: 3

方法1-show parameter



方法2-V$Parameter


V$Parameter和Show Parameter的区别


V$Parameter能得到更多的信息,但show parameter更简单而且它会自动完成“通配”


如何修改数据库的parameter


-- MEMORY - This affects the database now; but will not remain after a restart.
-- SPfile - This does not change the instance immediately, but will modify the SPfile takes effect after a restart.
-- BOTH - change both the current instance and the spfile.