GV$TEMPFILE definition in Oracle 10g / www.oracledba.ru
GV$TEMPFILE
select
tf.inst_id, -- INST_ID NUMBER
tf.tfnum, -- FILE# NUMBER
to_number -- CREATION_CHANGE# NUMBER
(tf.tfcrc_scn),
to_date -- CREATION_TIME DATE
(tf.tfcrc_tim, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
tf.tftsn, -- TS# NUMBER
tf.tfrfn, -- RFILE# NUMBER
decode -- STATUS VARCHAR2(7)
(bitand (tf.tfsta, 2), 0, 'OFFLINE', 2, 'ONLINE', 'UNKNOWN'),
decode -- ENABLED VARCHAR2(10)
(bitand (tf.tfsta, 12), 0, 'DISABLED', 4, 'READ ONLY', 12, 'READ WRITE', 'UNKNOWN'),
fh.fhtmpfsz*tf.tfbsz, -- BYTES NUMBER
fh.fhtmpfsz, -- BLOCKS NUMBER
tf.tfcsz*tf.tfbsz, -- CREATE_BYTES NUMBER
tf.tfbsz, -- BLOCK_SIZE NUMBER
fn.fnnam -- NAME VARCHAR2(513)
from
x$kcctf tf,
x$kccfn fn,
x$kcvfhtmp fh
where
fn.fnfno=tf.tfnum and fn.fnfno=fh.htmpxfil and tf.tffnh=fn.fnnum and tf.tfdup!=0 and fn.fntyp=7 and fn.fnnam is not null