DBA Data[Home] [Help]

VIEW: SYS.V_$UNDOSTAT

Source

View Text - Preformatted

select "BEGIN_TIME","END_TIME","UNDOTSN","UNDOBLKS","TXNCOUNT","MAXQUERYLEN","MAXQUERYID","MAXCONCURRENCY","UNXPSTEALCNT","UNXPBLKRELCNT","UNXPBLKREUCNT","EXPSTEALCNT","EXPBLKRELCNT","EXPBLKREUCNT","SSOLDERRCNT","NOSPACEERRCNT","ACTIVEBLKS","UNEXPIREDBLKS","EXPIREDBLKS","TUNED_UNDORETENTION","CON_ID" from v$undostat
View Text - HTML Formatted

SELECT "BEGIN_TIME"
, "END_TIME"
, "UNDOTSN"
, "UNDOBLKS"
, "TXNCOUNT"
, "MAXQUERYLEN"
, "MAXQUERYID"
, "MAXCONCURRENCY"
, "UNXPSTEALCNT"
, "UNXPBLKRELCNT"
, "UNXPBLKREUCNT"
, "EXPSTEALCNT"
, "EXPBLKRELCNT"
, "EXPBLKREUCNT"
, "SSOLDERRCNT"
, "NOSPACEERRCNT"
, "ACTIVEBLKS"
, "UNEXPIREDBLKS"
, "EXPIREDBLKS"
, "TUNED_UNDORETENTION"
, "CON_ID"
FROM V$UNDOSTAT