Database Administration (MOSC)

MOSC Banner

TUNED_UNDORETENTION is zero

edited Nov 8, 2012 6:55PM in Database Administration (MOSC) 3 commentsAnswered ✓
 Hello Expert,
Can we check why TUNED_UNDORETENTION is 0..? 

SQL> select banner from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for Solaris: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

SQL> show parameter statistics_level

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
statistics_level                     string      TYPICAL
SQL> select begin_time,ssolderrcnt from v$undostat;

BEGIN_TIME          SSOLDERRCNT
------------------- -----------
2012-06-01 19:02:14          78

SQL>  select BEGIN_TIME,END_TIME , TUNED_UNDORETENTION from v$undostat;

BEGIN_TIME          END_TIME            TUNED_UNDORETENTION
------------------- ------------------- -------------------
2012-06-01 19:02:14 2012-11-09 03:59:20                   0

SQL> select begin_time,maxquerylen from v$undostat;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center