Oracle TUNE V$UNDOSTAT(三)
SQL> select begin_time,end_time from v$un
dostat;
BEGIN_TIME END_TIME
------------------- -------------------
2013-05-14 16:22:35 2013-05-14 16:24:00
SQL> select begin_time,end_time from v$undostat;
BEGIN_TIME END_TIME
------------------- -------------------
2013-05-14 16:22:35 2013-05-14 16:54:27
可以看到都过了半个小时了还没有插入新的纪录。
设置_undo_autotune =TRUE 时候：
SQL> alter system set "_undo_autotune"=TRUE scope=both;
System altered.
SQL> select begin_time,end_time from v$undostat;
BEGIN_TIME END_TIME
------------------- -------------------
2013-05-14 17:02:35 2013-05-14 17:05:37
2013-05-14 16:52:35 2013-05-14 17:02:35
2013-05-14 16:32:35 2013-05-14 16:52:35
2013-05-14 16:22:35 2013-05-14 16:32:35
这样就由恢复自动收集的状态了。
-EOF-