select
FILE#, -- FILE# NUMBER
PHYRDS, -- PHYRDS NUMBER
PHYWRTS, -- PHYWRTS NUMBER
PHYBLKRD, -- PHYBLKRD NUMBER
PHYBLKWRT, -- PHYBLKWRT NUMBER
SINGLEBLKRDS, -- SINGLEBLKRDS NUMBER
READTIM, -- READTIM NUMBER
WRITETIM, -- WRITETIM NUMBER
SINGLEBLKRDTIM, -- SINGLEBLKRDTIM NUMBER
AVGIOTIM, -- AVGIOTIM NUMBER
LSTIOTIM, -- LSTIOTIM NUMBER
MINIOTIM, -- MINIOTIM NUMBER
MAXIORTM, -- MAXIORTM NUMBER
MAXIOWTM -- MAXIOWTM NUMBER
from
GV$TEMPSTAT
where
inst_id = USERENV('Instance')