select
  indx,                                    -- INDX NUMBER
  hash,                                    -- HASH NUMBER
  address,                                 -- ADDRESS RAW(8)
  cache#,                                  -- CACHE# NUMBER
  subcache#,                               -- SUBCACHE# NUMBER
  subcache_name,                           -- SUBCACHE_NAME VARCHAR2(64)
  existent,                                -- EXISTENT VARCHAR2(1)
  parent,                                  -- PARENT RAW(8)
  key                                      -- KEY RAW(100)
from
  gv$rowcache_subordinate
where
  inst_id = USERENV('Instance')