V$ARCHIVE_DEST definition in Oracle Database 11.2
V$ARCHIVE_DEST

select
  DEST_ID,                                 -- DEST_ID NUMBER
  DEST_NAME,                               -- DEST_NAME VARCHAR2(256)
  STATUS,                                  -- STATUS VARCHAR2(9)
  BINDING,                                 -- BINDING VARCHAR2(9)
  NAME_SPACE,                              -- NAME_SPACE VARCHAR2(7)
  TARGET,                                  -- TARGET VARCHAR2(7)
  ARCHIVER,                                -- ARCHIVER VARCHAR2(10)
  SCHEDULE,                                -- SCHEDULE VARCHAR2(8)
  DESTINATION,                             -- DESTINATION VARCHAR2(256)
  LOG_SEQUENCE,                            -- LOG_SEQUENCE NUMBER
  REOPEN_SECS,                             -- REOPEN_SECS NUMBER
  DELAY_MINS,                              -- DELAY_MINS NUMBER
  MAX_CONNECTIONS,                         -- MAX_CONNECTIONS NUMBER
  NET_TIMEOUT,                             -- NET_TIMEOUT NUMBER
  PROCESS,                                 -- PROCESS VARCHAR2(10)
  REGISTER,                                -- REGISTER VARCHAR2(3)
  FAIL_DATE,                               -- FAIL_DATE DATE
  FAIL_SEQUENCE,                           -- FAIL_SEQUENCE NUMBER
  FAIL_BLOCK,                              -- FAIL_BLOCK NUMBER
  FAILURE_COUNT,                           -- FAILURE_COUNT NUMBER
  MAX_FAILURE,                             -- MAX_FAILURE NUMBER
  ERROR,                                   -- ERROR VARCHAR2(256)
  ALTERNATE,                               -- ALTERNATE VARCHAR2(256)
  DEPENDENCY,                              -- DEPENDENCY VARCHAR2(256)
  REMOTE_TEMPLATE,                         -- REMOTE_TEMPLATE VARCHAR2(256)
  QUOTA_SIZE,                              -- QUOTA_SIZE NUMBER
  QUOTA_USED,                              -- QUOTA_USED NUMBER
  MOUNTID,                                 -- MOUNTID NUMBER
  TRANSMIT_MODE,                           -- TRANSMIT_MODE VARCHAR2(12)
  ASYNC_BLOCKS,                            -- ASYNC_BLOCKS NUMBER
  AFFIRM,                                  -- AFFIRM VARCHAR2(3)
  TYPE,                                    -- TYPE VARCHAR2(7)
  VALID_NOW,                               -- VALID_NOW VARCHAR2(16)
  VALID_TYPE,                              -- VALID_TYPE VARCHAR2(15)
  VALID_ROLE,                              -- VALID_ROLE VARCHAR2(12)
  DB_UNIQUE_NAME,                          -- DB_UNIQUE_NAME VARCHAR2(30)
  VERIFY,                                  -- VERIFY VARCHAR2(3)
  COMPRESSION                              -- COMPRESSION VARCHAR2(7)
from
  GV$ARCHIVE_DEST
where
  inst_id = USERENV('Instance')

home |  up