星期四, 12月 01, 2011

Oracle 如何檢查隱含參數 ( implicit parameter )是否生效

Oracle 9i 如何檢查隱含參數是否生效


SQL> alter system set "_log_archive_callout"='LOCAL_FIRST=TRUE' ;
system altered.
-
Verify
select ksppinm, ksppstvl
from x$ksppi pi, x$ksppcv cv
where cv.indx=pi.indx and pi.ksppinm ='_log_archive_callout';
-
另一個隱含參數:
_allow_resetlogs_corruption= true   (如果redo損毀,或在重建controlfile,到open狀態時有錯 : ORA-01194: file 1 needs more recovery to be consistent )

沒有留言:

LinkWithin-相關文件

Related Posts Plugin for WordPress, Blogger...