select
  RECID,                                   -- RECID NUMBER
  STAMP,                                   -- STAMP NUMBER
  DEVICE_TYPE,                             -- DEVICE_TYPE VARCHAR2(17)
  HANDLE,                                  -- HANDLE VARCHAR2(513)
  COMMENTS,                                -- COMMENTS VARCHAR2(81)
  MEDIA,                                   -- MEDIA VARCHAR2(65)
  MEDIA_POOL,                              -- MEDIA_POOL NUMBER
  TAG,                                     -- TAG VARCHAR2(32)
  STATUS,                                  -- STATUS VARCHAR2(1)
  DELETED,                                 -- DELETED VARCHAR2(3)
  FILE#,                                   -- FILE# NUMBER
  CREATION_CHANGE#,                        -- CREATION_CHANGE# NUMBER
  CREATION_TIME,                           -- CREATION_TIME DATE
  RESETLOGS_CHANGE#,                       -- RESETLOGS_CHANGE# NUMBER
  RESETLOGS_TIME,                          -- RESETLOGS_TIME DATE
  CHECKPOINT_CHANGE#,                      -- CHECKPOINT_CHANGE# NUMBER
  CHECKPOINT_TIME,                         -- CHECKPOINT_TIME DATE
  ABSOLUTE_FUZZY_CHANGE#,                  -- ABSOLUTE_FUZZY_CHANGE# NUMBER
  RECOVERY_FUZZY_CHANGE#,                  -- RECOVERY_FUZZY_CHANGE# NUMBER
  RECOVERY_FUZZY_TIME,                     -- RECOVERY_FUZZY_TIME DATE
  INCREMENTAL_LEVEL,                       -- INCREMENTAL_LEVEL NUMBER
  ONLINE_FUZZY,                            -- ONLINE_FUZZY VARCHAR2(3)
  BACKUP_FUZZY,                            -- BACKUP_FUZZY VARCHAR2(3)
  BLOCKS,                                  -- BLOCKS NUMBER
  BLOCK_SIZE,                              -- BLOCK_SIZE NUMBER
  OLDEST_OFFLINE_RANGE,                    -- OLDEST_OFFLINE_RANGE NUMBER
  START_TIME,                              -- START_TIME DATE
  COMPLETION_TIME,                         -- COMPLETION_TIME DATE
  ELAPSED_SECONDS,                         -- ELAPSED_SECONDS NUMBER
  CONTROLFILE_TYPE,                        -- CONTROLFILE_TYPE VARCHAR2(1)
  KEEP,                                    -- KEEP VARCHAR2(3)
  KEEP_UNTIL,                              -- KEEP_UNTIL DATE
  KEEP_OPTIONS,                            -- KEEP_OPTIONS VARCHAR2(11)
  RMAN_STATUS_RECID,                       -- RMAN_STATUS_RECID NUMBER
  RMAN_STATUS_STAMP,                       -- RMAN_STATUS_STAMP NUMBER
  FOREIGN_DBID,                            -- FOREIGN_DBID NUMBER
  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$PROXY_DATAFILE
where
  inst_id = USERENV('Instance')