No data in the View Dba_hist_undostat (document ID 1558157.1)

Applies To:

Oracle database-enterprise edition-version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms

This was a busy database.but no data found in view Dba_hist_undostat.

Sql>select * from Dba_hist_undostat;

No rows selected

AWR snapshots Complete Successfully,but The view Wrh$_undostat is also empty.

Changes

Parameter _undo_autotune is set to false recently

Cause

This issue was caused by _undo_autotune=false

Auto undo tuning has been disabled.

If the parameter _undo_autotune=false, there would be no data generated in table X$ktusmst2 which is the source table of VI EW Dba_hist_undostats

Solution

Proper Solution:

Modify parameter _undo_autotune to True,you can use following commad:

Alter system set "_undo_autotune" =true Scope=both;

No data in the View Dba_hist_undostat (document ID 1558157.1)