Retention of data in view v$undostat
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
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
0