GV$UNDOSTAT definition in Oracle Database 11.2
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

home |  up