V$TEMP_PING definition in Oracle Database 11.2
V$TEMP_PING

select
  file_number,                             -- FILE_NUMBER NUMBER
  frequency,                               -- FREQUENCY 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
  x_2_ssx,                                 -- X_2_SSX NUMBER
  x_2_ssx_forced_write,                    -- X_2_SSX_FORCED_WRITE NUMBER
  s_2_null,                                -- S_2_NULL NUMBER
  s_2_null_forced_stale,                   -- S_2_NULL_FORCED_STALE NUMBER
  ss_2_null,                               -- SS_2_NULL NUMBER
  ss_2_rls,                                -- SS_2_RLS NUMBER
  wrb,                                     -- WRB NUMBER
  wrb_forced_write,                        -- WRB_FORCED_WRITE NUMBER
  rbr,                                     -- RBR NUMBER
  rbr_forced_write,                        -- RBR_FORCED_WRITE NUMBER
  rbr_forced_stale,                        -- RBR_FORCED_STALE NUMBER
  cbr,                                     -- CBR NUMBER
  cbr_forced_write,                        -- CBR_FORCED_WRITE NUMBER
  null_2_x,                                -- NULL_2_X NUMBER
  s_2_x,                                   -- S_2_X NUMBER
  ssx_2_x,                                 -- SSX_2_X NUMBER
  null_2_s,                                -- NULL_2_S NUMBER
  null_2_ss,                               -- NULL_2_SS NUMBER
  op_2_ss                                  -- OP_2_SS NUMBER
from
  gv$temp_ping
where
  inst_id = USERENV('Instance')

home |  up