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 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 from X$KTUSMST

home |  up  |  mailbox