GV$DATAFILE definition in Oracle 8i / www.oracledba.ru
GV$DATAFILE
select
fe.inst_id, -- INST_ID NUMBER
fe.fenum, -- FILE# NUMBER
to_number -- CREATION_CHANGE# NUMBER
(fe.fecrc_scn),
to_date -- CREATION_TIME DATE
(fe.fecrc_tim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
fe.fetsn, -- TS# NUMBER
fe.ferfn, -- RFILE# NUMBER
decode -- STATUS VARCHAR2(7)
(fe.fetsn, 0, decode (bitand (fe.festa, 2), 0, 'SYSOFF', 'SYSTEM'), decode (bitand (fe.festa, 18), 0, 'OFFLINE', 2, 'ONLINE', 'RECOVER')),
decode -- ENABLED VARCHAR2(10)
(fe.fedor, 2, 'READ ONLY', decode (bitand (fe.festa, 12), 0, 'DISABLED', 4, 'READ ONLY', 12, 'READ WRITE', 'UNKNOWN')),
to_number (fe.fecps), -- CHECKPOINT_CHANGE# NUMBER
to_date -- CHECKPOINT_TIME DATE
(fe.fecpt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (fe.feurs), -- UNRECOVERABLE_CHANGE# NUMBER
to_date -- UNRECOVERABLE_TIME DATE
(fe.feurt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_number (fe.fests), -- LAST_CHANGE# NUMBER
decode -- LAST_TIME DATE
(fe.fests, NULL, to_date (NULL), to_date (fe.festt, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian')),
to_number (fe.feofs), -- OFFLINE_CHANGE# NUMBER
to_number -- ONLINE_CHANGE# NUMBER
(fe.feonc_scn),
to_date -- ONLINE_TIME DATE
(fe.feonc_tim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
fh.fhfsz*fe.febsz, -- BYTES NUMBER
fh.fhfsz, -- BLOCKS NUMBER
fe.fecsz*fe.febsz, -- CREATE_BYTES NUMBER
fe.febsz, -- BLOCK_SIZE NUMBER
fn.fnnam, -- NAME VARCHAR2(513)
fe.fefdb -- PLUGGED_IN NUMBER
from
x$kccfe fe,
x$kccfn fn,
x$kcvfh fh
where
fn.fnfno=fe.fenum and fn.fnfno=fh.hxfil and fe.fefnh=fn.fnnum and fe.fedup!=0 and fn.fntyp=4 and fn.fnnam is not null