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)
  CHECKPOINT_CHANGE#,                      -- CHECKPOINT_CHANGE# NUMBER
  CHECKPOINT_TIME,                         -- CHECKPOINT_TIME DATE
  UNRECOVERABLE_CHANGE#,                   -- UNRECOVERABLE_CHANGE# NUMBER
  UNRECOVERABLE_TIME,                      -- UNRECOVERABLE_TIME DATE
  LAST_CHANGE#,                            -- LAST_CHANGE# NUMBER
  LAST_TIME,                               -- LAST_TIME DATE
  OFFLINE_CHANGE#,                         -- OFFLINE_CHANGE# NUMBER
  ONLINE_CHANGE#,                          -- ONLINE_CHANGE# NUMBER
  ONLINE_TIME,                             -- ONLINE_TIME DATE
  BYTES,                                   -- BYTES NUMBER
  BLOCKS,                                  -- BLOCKS NUMBER
  CREATE_BYTES,                            -- CREATE_BYTES NUMBER
  BLOCK_SIZE,                              -- BLOCK_SIZE NUMBER
  NAME,                                    -- NAME VARCHAR2(513)
  PLUGGED_IN,                              -- PLUGGED_IN NUMBER
  BLOCK1_OFFSET,                           -- BLOCK1_OFFSET NUMBER
  AUX_NAME,                                -- AUX_NAME VARCHAR2(513)
  FIRST_NONLOGGED_SCN,                     -- FIRST_NONLOGGED_SCN NUMBER
  FIRST_NONLOGGED_TIME,                    -- FIRST_NONLOGGED_TIME DATE
  FOREIGN_DBID,                            -- FOREIGN_DBID NUMBER
  FOREIGN_CREATION_CHANGE#,                -- FOREIGN_CREATION_CHANGE# NUMBER
  FOREIGN_CREATION_TIME,                   -- FOREIGN_CREATION_TIME DATE
  PLUGGED_READONLY,                        -- PLUGGED_READONLY VARCHAR2(3)
  PLUGIN_CHANGE#,                          -- PLUGIN_CHANGE# NUMBER
  PLUGIN_RESETLOGS_CHANGE#,                -- PLUGIN_RESETLOGS_CHANGE# NUMBER
  PLUGIN_RESETLOGS_TIME                    -- PLUGIN_RESETLOGS_TIME DATE
from
  GV$DATAFILE
where
  inst_id = USERENV('Instance')