GV$UNDOSTAT definition in Oracle Database 10.2 / www.oracledba.ru
GV$UNDOSTAT
select
inst_id, -- INST_ID NUMBER
to_date -- BEGIN_TIME DATE
(KTUSMSTRBEGTIME, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_date -- END_TIME DATE
(KTUSMSTRENDTIME, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
KTUSMSTTSN, -- UNDOTSN NUMBER
KTUSMSTUSU, -- UNDOBLKS NUMBER
KTUSMSTTCT, -- TXNCOUNT NUMBER
KTUSMSTMQL, -- MAXQUERYLEN NUMBER
KTUSMSTRMQI, -- MAXQUERYID VARCHAR2(13)
KTUSMSTMTC, -- MAXCONCURRENCY NUMBER
KTUSMSTUAC, -- UNXPSTEALCNT NUMBER
KTUSMSTUBS, -- UNXPBLKRELCNT NUMBER
KTUSMSTUBR, -- UNXPBLKREUCNT NUMBER
KTUSMSTXAC, -- EXPSTEALCNT NUMBER
KTUSMSTXBS, -- EXPBLKRELCNT NUMBER
KTUSMSTXBR, -- EXPBLKREUCNT NUMBER
KTUSMSTSOC, -- SSOLDERRCNT NUMBER
KTUSMSTOOS, -- NOSPACEERRCNT NUMBER
KTUSMSTABK, -- ACTIVEBLKS NUMBER
KTUSMSTUBK, -- UNEXPIREDBLKS NUMBER
KTUSMSTEBK, -- EXPIREDBLKS NUMBER
KTUSMSTTUR -- TUNED_UNDORETENTION NUMBER
from
X$KTUSMST