V$PROXY_ARCHIVEDLOG definition in Oracle Database 11.2
V$PROXY_ARCHIVEDLOG

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)
  THREAD#,                                 -- THREAD# NUMBER
  SEQUENCE#,                               -- SEQUENCE# NUMBER
  RESETLOGS_CHANGE#,                       -- RESETLOGS_CHANGE# NUMBER
  RESETLOGS_TIME,                          -- RESETLOGS_TIME DATE
  FIRST_CHANGE#,                           -- FIRST_CHANGE# NUMBER
  FIRST_TIME,                              -- FIRST_TIME DATE
  NEXT_CHANGE#,                            -- NEXT_CHANGE# NUMBER
  NEXT_TIME,                               -- NEXT_TIME DATE
  BLOCKS,                                  -- BLOCKS NUMBER
  BLOCK_SIZE,                              -- BLOCK_SIZE NUMBER
  START_TIME,                              -- START_TIME DATE
  COMPLETION_TIME,                         -- COMPLETION_TIME DATE
  ELAPSED_SECONDS,                         -- ELAPSED_SECONDS NUMBER
  RMAN_STATUS_RECID,                       -- RMAN_STATUS_RECID NUMBER
  RMAN_STATUS_STAMP,                       -- RMAN_STATUS_STAMP NUMBER
  TERMINAL,                                -- TERMINAL VARCHAR2(3)
  KEEP,                                    -- KEEP VARCHAR2(3)
  KEEP_UNTIL,                              -- KEEP_UNTIL DATE
  KEEP_OPTIONS                             -- KEEP_OPTIONS VARCHAR2(11)
from
  GV$PROXY_ARCHIVEDLOG
where
  inst_id = USERENV('Instance')

home |  up