V$SESSION_CLIENT_RESULT_CACHE definition in Oracle Database 11.2

V$SESSION_CLIENT_RESULT_CACHE

select
  SID,                                     -- SID NUMBER
  SERIAL#,                                 -- SERIAL# NUMBER
  CSOADDR,                                 -- CSOADDR RAW(8)
  CACHE_ID                                 -- CACHE_ID NUMBER
from
  GV$SESSION_CLIENT_RESULT_CACHE
where
  inst_id=USERENV('Instance')

home | up