V$TEMP_EXTENT_POOL definition in Oracle Database 11.2

V$TEMP_EXTENT_POOL

select
  TABLESPACE_NAME,                         -- TABLESPACE_NAME VARCHAR2(30)
  FILE_ID,                                 -- FILE_ID NUMBER
  EXTENTS_CACHED,                          -- EXTENTS_CACHED NUMBER
  EXTENTS_USED,                            -- EXTENTS_USED NUMBER
  BLOCKS_CACHED,                           -- BLOCKS_CACHED NUMBER
  BLOCKS_USED,                             -- BLOCKS_USED NUMBER
  BYTES_CACHED,                            -- BYTES_CACHED NUMBER
  BYTES_USED,                              -- BYTES_USED NUMBER
  RELATIVE_FNO                             -- RELATIVE_FNO NUMBER
from
  GV$TEMP_EXTENT_POOL
where
  inst_id = USERENV('Instance')

home | up