Database Administration (MOSC)

MOSC Banner

Retention of data in view v$undostat

edited Feb 19, 2009 4:54PM in Database Administration (MOSC) 4 commentsAnswered
Hello,  
It seems that the view v$undostat doesn't access data since instance startup but only from some days.

Could explain me why?

Could you confirm me this view is built from the request (9i):
select to_date(KTUSMSTRBEGTIME,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'), to_date(KTUSMSTRENDTIME,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'), KTUSMSTTSN, KTUSMSTUSU, KTUSMSTTCT, KTUSMSTMQL, KTUSMSTMTC, KTUSMSTUAC, KTUSMSTUBS, KTUSMSTUBR, KTUSMSTXAC, KTUSMSTXBS, KTUSMSTXBR, KTUSMSTSOC from X$KTUSMST order by KTUSMSTRBEGTIME;

Could you give me information about X$KTUSMST?


Thanks in advance

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