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')

home |  up