DBA Data[Home] [Help]

VIEW: SYS.GV_$FILESTAT

Source

View Text - Preformatted

select "INST_ID","FILE#","PHYRDS","PHYWRTS","PHYBLKRD","OPTIMIZED_PHYBLKRD","PHYBLKWRT","SINGLEBLKRDS","READTIM","WRITETIM","SINGLEBLKRDTIM","AVGIOTIM","LSTIOTIM","MINIOTIM","MAXIORTM","MAXIOWTM","CON_ID" from gv$filestat
View Text - HTML Formatted

SELECT "INST_ID"
, "FILE#"
, "PHYRDS"
, "PHYWRTS"
, "PHYBLKRD"
, "OPTIMIZED_PHYBLKRD"
, "PHYBLKWRT"
, "SINGLEBLKRDS"
, "READTIM"
, "WRITETIM"
, "SINGLEBLKRDTIM"
, "AVGIOTIM"
, "LSTIOTIM"
, "MINIOTIM"
, "MAXIORTM"
, "MAXIOWTM"
, "CON_ID"
FROM GV$FILESTAT