GV$SESSION_OBJECT_CACHE
select inst_id, -- INST_ID NUMBER kocstpin, -- PINS NUMBER kocsthit, -- HITS NUMBER kocsttht, -- TRUE_HITS NUMBER decode -- HIT_RATIO NUMBER (kocstpin, 0, 1, kocsthit/kocstpin), decode -- TRUE_HIT_RATIO NUMBER (kocstpin, 0, 1, kocsttht/kocstpin), kocstorf, -- OBJECT_REFRESHES NUMBER kocstrfs, -- CACHE_REFRESHES NUMBER kocstofs, -- OBJECT_FLUSHES NUMBER kocstfls, -- CACHE_FLUSHES NUMBER kocstshr, -- CACHE_SHRINKS NUMBER kocstcnt, -- CACHED_OBJECTS NUMBER kocstpnd, -- PINNED_OBJECTS NUMBER kocstsiz, -- CACHE_SIZE NUMBER kocstopt, -- OPTIMAL_SIZE NUMBER kocstmax -- MAXIMUM_SIZE NUMBER from x$kocst

home |  up  |  mailbox