GV$SESSION_CURSOR_CACHE definition in Oracle Database 11.2

GV$SESSION_CURSOR_CACHE

select
  inst_id,                                 -- INST_ID NUMBER
  kgscugmax,                               -- MAXIMUM NUMBER
  kgscugcnt,                               -- COUNT NUMBER
  kgscugopn,                               -- OPENS NUMBER
  kgscughit,                               -- HITS NUMBER
  decode(                                  -- HIT_RATIO NUMBER
    kgscugopn,0,1,kgscughit/kgscugopn) 
from
  x$kgscc

home | up