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  |  mailbox