[Translated from mos] The v $ undostat view is not updated every 10 minutes. v $ undostat has only one row (one rows) and mosundostat.

[Translated from mos] The v $ undostat view is not updated every 10 minutes. v $ undostat has only one row (one rows) and mosundostat.

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.