v$undostat视图没有按照每10分钟进行更新，v$undostat只有1行（one rows） 参考原文： the v$undostat view is not getting updated in every 10 minutes. (doc id 1206365.1) 适用于： oracle server - enterprise edition - version: 10.2.0.1 and later [
v$undostat视图没有按照每10分钟进行更新，v$undostat只有1行（one rows）
参考原文：
the v$undostat view is not getting updated in every 10 minutes. (doc id 1206365.1)
适用于：
oracle server - enterprise edition - version: 10.2.0.1 and later [release: 10.2 and later ]
information in this document applies to any platform.
症状：
the v$undostat view is not getting updated every 10 minutes.
sql> select begin_time,end_time, undoblks from v$undostat;
begin_time end_time undoblks
-------------------- -------------------- ----------
21-aug-2010 03:48:44 07-sep-2010 11:02:14 75016989
以上查询只返回1行。
变化：
sql> sho parameter undo
name type value
------------------------------------ ----------- ------------------------------
_in_memory_undo boolean false
_undo_autotune boolean false --->注意此行记录。
undo_management string auto
undo_retention integer 3600
undo_tablespace string undotbs1
the parameter _undo_autotune has been set to false.
this has disabled automatic undo tuning.
解决方案：
设置_undo_autotune parameter to true:
sql> alter system set _undo_autotune=true;
this disables the standard tracking of undo statistics in v$undostat. you can see only the one row of data as noted in this case.