-- 查询隐含参数 select ksppinm, ksppstvl from x$ksppi pi, x$ksppcv cv where cv.indx = pi.indx and pi.ksppinm like '_undo_autotune%' 可以看到默认是true . SQL> ALTER SESSION SET NLS_DATE_FORMAT='YYYY/MM/DD HH24:MI:SS' ; Session altered.
v$undostat中查看调整优化后的undo_retention (tuned_undoretention).
SQL> SELECT begin_time, end_time, tuned_undoretention FROM v$undostat;
BEGIN_TIME END_TIME TUNED_UNDORETENTION ------------------- ------------------- -------------------
2012/07/29 16:43:37 2012/07/29 16:53:37 2120462
v$undostat中查看调整优化后的undo_retention (tuned_undoretention).
SQL> SELECT begin_time, end_time, tuned_undoretention FROM v$undostat;
BEGIN_TIME END_TIME TUNED_UNDORETENTION ------------------- ------------------- -------------------
2012/07/29 16:43:37 2012/07/29 16:53:37 2120462
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25462274/viewspace-2123508/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
