GV$DATAFILE_HEADER definition in Oracle Database 10.2 / www.oracledba.ru
GV$DATAFILE_HEADER
select
inst_id, -- INST_ID NUMBER
hxfil, -- FILE# NUMBER
decode -- STATUS VARCHAR2(7)
(hxons, 0, 'OFFLINE', 'ONLINE'),
decode -- ERROR VARCHAR2(18)
(hxerr, 0, NULL, 1, 'FILE MISSING', 2, 'OFFLINE NORMAL', 3, 'NOT VERIFIED', 4, 'FILE NOT FOUND', 5, 'CANNOT OPEN FILE', 6, 'CANNOT READ HEADER', 7, 'CORRUPT HEADER', 8, 'WRONG FILE TYPE', 9, 'WRONG DATABASE', 10, 'WRONG FILE NUMBER', 11, 'WRONG FILE CREATE', 12, 'WRONG FILE CREATE', 16, 'DELAYED OPEN', 14, 'WRONG RESETLOGS', 15, 'OLD CONTROLFILE', 'UNKNOWN ERROR'),
hxver, -- FORMAT NUMBER
decode -- RECOVER VARCHAR2(3)
(hxnrcv, 0, 'NO', 1, 'YES', NULL),
decode -- FUZZY VARCHAR2(3)
(hxifz, 0, 'NO', 1, 'YES', NULL),
to_number (fhcrs), -- CREATION_CHANGE# NUMBER
to_date -- CREATION_TIME DATE
(fhcrt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
fhtnm, -- TABLESPACE_NAME VARCHAR2(30)
fhtsn, -- TS# NUMBER
fhrfn, -- RFILE# NUMBER
to_number (fhrls), -- RESETLOGS_CHANGE# NUMBER
to_date -- RESETLOGS_TIME DATE
(fhrlc, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (fhscn), -- CHECKPOINT_CHANGE# NUMBER
to_date -- CHECKPOINT_TIME DATE
(fhtim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
fhcpc, -- CHECKPOINT_COUNT NUMBER
fhfsz*fhbsz, -- BYTES NUMBER
fhfsz, -- BLOCKS NUMBER
hxfnm, -- NAME VARCHAR2(513)
decode -- SPACE_HEADER VARCHAR2(40)
(hxlmdba, 0, NULL, hxlmdba),
decode -- LAST_DEALLOC_SCN VARCHAR2(16)
(hxlmld_scn, '0', NULL, hxlmld_scn)
from
x$kcvfh