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