eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.V_$ROLLSTAT

Object Details

Object Name:	V_$ROLLSTAT
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
USN	NUMBER
LATCH	NUMBER
EXTENTS	NUMBER
RSSIZE	NUMBER
WRITES	NUMBER
XACTS	NUMBER
GETS	NUMBER
WAITS	NUMBER
OPTSIZE	NUMBER
HWMSIZE	NUMBER
SHRINKS	NUMBER
WRAPS	NUMBER
EXTENDS	NUMBER
AVESHRINK	NUMBER
AVEACTIVE	NUMBER
STATUS	VARCHAR2	(15)
CUREXT	NUMBER
CURBLK	NUMBER
CON_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT USN
,      LATCH
,      EXTENTS
,      RSSIZE
,      WRITES
,      XACTS
,      GETS
,      WAITS
,      OPTSIZE
,      HWMSIZE
,      SHRINKS
,      WRAPS
,      EXTENDS
,      AVESHRINK
,      AVEACTIVE
,      STATUS
,      CUREXT
,      CURBLK
,      CON_ID
FROM SYS.V_$ROLLSTAT;

Dependencies

[top of page]

SYS.V_$ROLLSTAT references the following:

SYS.V_$ROLLSTAT is referenced by following:

PUBLIC: V$ROLLSTAT