GV$PROXY_DATAFILE

select
inst_id,                 -- INST_ID NUMBER
pcrid,                   -- RECID NUMBER
pcstm,                   -- STAMP NUMBER
pcdev,                   -- DEVICE_TYPE VARCHAR2(17)
pchdl,                   -- HANDLE VARCHAR2(513)
pccmt,                   -- COMMENTS VARCHAR2(81)
pcmdh,                   -- MEDIA VARCHAR2(65)
pcmpl,                   -- MEDIA_POOL NUMBER
pctag,                   -- TAG VARCHAR2(32)
decode                   -- STATUS VARCHAR2(1)
  (bitand (pcflg, 1+2+4), 0, 'A', 1, 'D', 2, 'X', 4, 'U', '?'),
decode                   -- DELETED VARCHAR2(3)
  (bitand (pcflg, 1), 1, 'YES', 'NO'),
pddfp,                   -- FILE# NUMBER
to_number (pdcrs),       -- CREATION_CHANGE# NUMBER
to_date                  -- CREATION_TIME DATE
  (pdcrt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (pdrls),       -- RESETLOGS_CHANGE# NUMBER
to_date                  -- RESETLOGS_TIME DATE
  (pdrlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (pdcps),       -- CHECKPOINT_CHANGE# NUMBER
to_date                  -- CHECKPOINT_TIME DATE
  (pdcpt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (pdafs),       -- ABSOLUTE_FUZZY_CHANGE# NUMBER
to_number (pdrfs),       -- RECOVERY_FUZZY_CHANGE# NUMBER
to_date                  -- RECOVERY_FUZZY_TIME DATE
  (pdrft, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode                   -- INCREMENTAL_LEVEL NUMBER
  (bitand (pdflg, 1), 1, 0, NULL),
decode                   -- ONLINE_FUZZY VARCHAR2(3)
  (bitand (pdflg, 2), 0, 'NO', 'YES'),
decode                   -- BACKUP_FUZZY VARCHAR2(3)
  (bitand (pdflg, 4), 0, 'NO', 'YES'),
pdfsz,                   -- BLOCKS NUMBER
pdbsz,                   -- BLOCK_SIZE NUMBER
pdlor,                   -- OLDEST_OFFLINE_RANGE NUMBER
to_date                  -- START_TIME DATE
  (pctsm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_date                  -- COMPLETION_TIME DATE
  (pctim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
(to_date                 -- ELAPSED_SECONDS NUMBER
  (pctim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian') - to_date (pctsm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian')) *86400,
decode                   -- CONTROLFILE_TYPE VARCHAR2(1)
  (pddfp, 0, decode (bitand (pcflg, 8), 8, 'S', 'B'), NULL),
decode                   -- KEEP VARCHAR2(3)
  (bitand (pdflg, 1792), 0, 'NO', 'YES'),
to_date                  -- KEEP_UNTIL DATE
  (pdkpt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode                   -- KEEP_OPTIONS VARCHAR2(10)
  (bitand (pdflg, 1792), 256, 'LOGS', 512, 'NOLOGS', 1024, 'CONSISTENT', NULL) 
from
x$kccpd
home |  up  |  mailbox