The v $ undostat view is not updated every 10 minutes. For more information about the v $ undostat view, see the original article TheV $ UNDOSTATviewisnotgettingupdatedinevery10minutes. (DocID1206365.1). Applicable to: OracleServer
The v $ undostat view is not updated every 10 minutes. For more information, see The original article: The v $ undostat view is not getting updated in every 10 minutes. (Doc ID 1206365.1) applicable to: Oracle Server-Enterprise Edition-Version: 10.2.0.1 and later [
The v $ undostat view is not updated every 10 minutes. v $ undostat has only one row (one rows)
Reference Original:
The V $ UNDOSTAT view is not getting updated in every 10 minutes. (Doc ID 1206365.1)
Applicable:
Oracle Server-Enterprise Edition-Version: 10.2.0.1 and later [Release: 10.2 and later]
Information in this document applies to any platform.
Symptoms:
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
Only one row is returned for the preceding query.
Changes:
SQL> sho parameter undo
NAME TYPE VALUE
-----------------------------------------------------------------------------
_ In_memory_undo boolean FALSE
_ Undo_autotune boolean FALSE ---> pay attention to this row record.
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 IC undo tuning.
Solution:
Set "_ 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.