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')