GV$TEMP_CACHE_TRANSFER definition in Oracle Database 11.2
GV$TEMP_CACHE_TRANSFER

select
  x.inst_id,                               -- INST_ID NUMBER
  kcftiofno,                               -- FILE_NUMBER NUMBER
  0,                                       -- X_2_NULL NUMBER
  0,                                       -- X_2_NULL_FORCED_WRITE NUMBER
  0,                                       -- X_2_NULL_FORCED_STALE NUMBER
  0,                                       -- X_2_S NUMBER
  0,                                       -- X_2_S_FORCED_WRITE NUMBER
  0,                                       -- S_2_NULL NUMBER
  0,                                       -- S_2_NULL_FORCED_STALE NUMBER
  0,                                       -- RBR NUMBER
  0,                                       -- RBR_FORCED_WRITE NUMBER
  0,                                       -- NULL_2_X NUMBER
  0,                                       -- S_2_X NUMBER
  0                                        -- NULL_2_S NUMBER
from
  x$kcftio x,
  x$kcctf tf
where
  x.kcftiofno = tf.tfnum

home |  up