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'), abs -- ELAPSED_SECONDS NUMBER ((to_date (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), pcrsi, -- RMAN_STATUS_RECID NUMBER pcrst -- RMAN_STATUS_STAMP NUMBER from x$kccpd

home |  up  |  mailbox