V$TEMPSTAT definition in Oracle Database 11.2
V$TEMPSTAT

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')

home |  up