select
  INST_ID,                                 -- INST_ID NUMBER
  QESRCOBJ_MEM_LAD,                        -- ID NUMBER
  decode(                                  -- TYPE VARCHAR2(10)
    QESRCOBJ_CAC_TYP, 1,'Result', 2,'Dependency','Other'),
  decode(                                  -- STATUS VARCHAR2(9)
    QESRCOBJ_RSE_STA, 1,decode(QESRCOBJ_RSE_BYP,0,'New','Bypass'),2,'Published',3,'Invalid',4,'Expired','Other'),
  QESRCOBJ_CAC_BUC,                        -- BUCKET_NO NUMBER
  QESRCOBJ_CAC_HSV,                        -- HASH NUMBER
  QESRCOBJ_CAC_NAM,                        -- NAME VARCHAR2(128)
  decode(                                  -- NAMESPACE VARCHAR2(5)
    QESRCOBJ_CAC_NSP, 0, 'SQL', 1, 'PLSQL', 2, 'API', 3, 'AUTO'),
  QESRCOBJ_CAC_DAT,                        -- CREATION_TIMESTAMP DATE
  QESRCOBJ_CAC_UID,                        -- CREATOR_UID NUMBER
  QESRCOBJ_DEP_DCT,                        -- DEPEND_COUNT NUMBER
  QESRCOBJ_RSE_BCT,                        -- BLOCK_COUNT NUMBER
  QESRCOBJ_CAC_SCN,                        -- SCN NUMBER
  QESRCOBJ_RSE_CCT,                        -- COLUMN_COUNT NUMBER
  QESRCOBJ_RSE_PCT,                        -- PIN_COUNT NUMBER
  QESRCOBJ_RSE_SCT,                        -- SCAN_COUNT NUMBER
  QESRCOBJ_RSE_RCT,                        -- ROW_COUNT NUMBER
  QESRCOBJ_RSE_RMX,                        -- ROW_SIZE_MAX NUMBER
  QESRCOBJ_RSE_RMN,                        -- ROW_SIZE_MIN NUMBER
  QESRCOBJ_RSE_RAG,                        -- ROW_SIZE_AVG NUMBER
  QESRCOBJ_RSE_ETM,                        -- BUILD_TIME NUMBER
  QESRCOBJ_RSE_POS,                        -- LRU_NUMBER NUMBER
  QESRCOBJ_DEP_OBJ,                        -- OBJECT_NO NUMBER
  QESRCOBJ_DEP_INV,                        -- INVALIDATIONS NUMBER
  QESRCOBJ_RSE_SPO,                        -- SPACE_OVERHEAD NUMBER
  QESRCOBJ_RSE_SPU,                        -- SPACE_UNUSED NUMBER
  QESRCOBJ_CAC_CID,                        -- CACHE_ID VARCHAR2(93)
  QESRCOBJ_CAC_KEY                         -- CACHE_KEY VARCHAR2(93)
from
  x$qesrcobj