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 )