select
  FILE#,                                   -- FILE# NUMBER
  CREATION_CHANGE#,                        -- CREATION_CHANGE# NUMBER
  CREATION_TIME,                           -- CREATION_TIME DATE
  TS#,                                     -- TS# NUMBER
  RFILE#,                                  -- RFILE# NUMBER
  STATUS,                                  -- STATUS VARCHAR2(7)
  ENABLED,                                 -- ENABLED VARCHAR2(10)
  BYTES,                                   -- BYTES NUMBER
  BLOCKS,                                  -- BLOCKS NUMBER
  CREATE_BYTES,                            -- CREATE_BYTES NUMBER
  BLOCK_SIZE,                              -- BLOCK_SIZE NUMBER
  NAME                                     -- NAME VARCHAR2(513)
from
  GV$TEMPFILE
where
  inst_id = USERENV('Instance')