select
  ID,                                      -- ID NUMBER
  TYPE,                                    -- TYPE VARCHAR2(10)
  STATUS,                                  -- STATUS VARCHAR2(9)
  BUCKET_NO,                               -- BUCKET_NO NUMBER
  HASH,                                    -- HASH NUMBER
  NAME,                                    -- NAME VARCHAR2(128)
  NAMESPACE,                               -- NAMESPACE VARCHAR2(5)
  CREATION_TIMESTAMP,                      -- CREATION_TIMESTAMP DATE
  CREATOR_UID,                             -- CREATOR_UID NUMBER
  DEPEND_COUNT,                            -- DEPEND_COUNT NUMBER
  BLOCK_COUNT,                             -- BLOCK_COUNT NUMBER
  SCN,                                     -- SCN NUMBER
  COLUMN_COUNT,                            -- COLUMN_COUNT NUMBER
  PIN_COUNT,                               -- PIN_COUNT NUMBER
  SCAN_COUNT,                              -- SCAN_COUNT NUMBER
  ROW_COUNT,                               -- ROW_COUNT NUMBER
  ROW_SIZE_MAX,                            -- ROW_SIZE_MAX NUMBER
  ROW_SIZE_MIN,                            -- ROW_SIZE_MIN NUMBER
  ROW_SIZE_AVG,                            -- ROW_SIZE_AVG NUMBER
  BUILD_TIME,                              -- BUILD_TIME NUMBER
  LRU_NUMBER,                              -- LRU_NUMBER NUMBER
  OBJECT_NO,                               -- OBJECT_NO NUMBER
  INVALIDATIONS,                           -- INVALIDATIONS NUMBER
  SPACE_OVERHEAD,                          -- SPACE_OVERHEAD NUMBER
  SPACE_UNUSED,                            -- SPACE_UNUSED NUMBER
  CACHE_ID,                                -- CACHE_ID VARCHAR2(93)
  CACHE_KEY                                -- CACHE_KEY VARCHAR2(93)
from
  GV$RESULT_CACHE_OBJECTS
where
  inst_id=USERENV('Instance')