DBA Data[Home] [Help]

VIEW: SYS.GV_$ROLLSTAT

Source

View Text - Preformatted

select "INST_ID","USN","LATCH","EXTENTS","RSSIZE","WRITES","XACTS","GETS","WAITS","OPTSIZE","HWMSIZE","SHRINKS","WRAPS","EXTENDS","AVESHRINK","AVEACTIVE","STATUS","CUREXT","CURBLK","CON_ID" from gv$rollstat
View Text - HTML Formatted

SELECT "INST_ID"
, "USN"
, "LATCH"
, "EXTENTS"
, "RSSIZE"
, "WRITES"
, "XACTS"
, "GETS"
, "WAITS"
, "OPTSIZE"
, "HWMSIZE"
, "SHRINKS"
, "WRAPS"
, "EXTENDS"
, "AVESHRINK"
, "AVEACTIVE"
, "STATUS"
, "CUREXT"
, "CURBLK"
, "CON_ID"
FROM GV$ROLLSTAT