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

VIEW: SYS.V_$TEMPSTAT

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
FILE# NUMBER

PHYRDS NUMBER

PHYWRTS NUMBER

PHYBLKRD NUMBER

PHYBLKWRT NUMBER

SINGLEBLKRDS NUMBER

READTIM NUMBER

WRITETIM NUMBER

SINGLEBLKRDTIM NUMBER

AVGIOTIM NUMBER

LSTIOTIM NUMBER

MINIOTIM NUMBER

MAXIORTM NUMBER

MAXIOWTM NUMBER

CON_ID NUMBER

Query Text

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


SELECT FILE#
,      PHYRDS
,      PHYWRTS
,      PHYBLKRD
,      PHYBLKWRT
,      SINGLEBLKRDS
,      READTIM
,      WRITETIM
,      SINGLEBLKRDTIM
,      AVGIOTIM
,      LSTIOTIM
,      MINIOTIM
,      MAXIORTM
,      MAXIOWTM
,      CON_ID
FROM SYS.V_$TEMPSTAT;

Dependencies

[top of page]

SYS.V_$TEMPSTAT references the following:

SYS.V_$TEMPSTAT is referenced by following:

SchemaPUBLIC
SynonymV$TEMPSTAT