V$TEMP_CACHE_TRANSFER definition in Oracle Database 11.2
V$TEMP_CACHE_TRANSFER
select
file_number, -- FILE_NUMBER NUMBER
x_2_null, -- X_2_NULL NUMBER
x_2_null_forced_write, -- X_2_NULL_FORCED_WRITE NUMBER
x_2_null_forced_stale, -- X_2_NULL_FORCED_STALE NUMBER
x_2_s, -- X_2_S NUMBER
x_2_s_forced_write, -- X_2_S_FORCED_WRITE NUMBER
s_2_null, -- S_2_NULL NUMBER
s_2_null_forced_stale, -- S_2_NULL_FORCED_STALE NUMBER
rbr, -- RBR NUMBER
rbr_forced_write, -- RBR_FORCED_WRITE NUMBER
null_2_x, -- NULL_2_X NUMBER
s_2_x, -- S_2_X NUMBER
null_2_s -- NULL_2_S NUMBER
from
gv$temp_cache_transfer
where
inst_id = USERENV('Instance')