[Home] [Help] [Dependency Information]
Object Name: | GV_$SESSION_OBJECT_CACHE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
PINS | NUMBER | |||
HITS | NUMBER | |||
TRUE_HITS | NUMBER | |||
HIT_RATIO | NUMBER | |||
TRUE_HIT_RATIO | NUMBER | |||
OBJECT_REFRESHES | NUMBER | |||
CACHE_REFRESHES | NUMBER | |||
OBJECT_FLUSHES | NUMBER | |||
CACHE_FLUSHES | NUMBER | |||
CACHE_SHRINKS | NUMBER | |||
CACHED_OBJECTS | NUMBER | |||
PINNED_OBJECTS | NUMBER | |||
CACHE_SIZE | NUMBER | |||
OPTIMAL_SIZE | NUMBER | |||
MAXIMUM_SIZE | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, PINS
, HITS
, TRUE_HITS
, HIT_RATIO
, TRUE_HIT_RATIO
, OBJECT_REFRESHES
, CACHE_REFRESHES
, OBJECT_FLUSHES
, CACHE_FLUSHES
, CACHE_SHRINKS
, CACHED_OBJECTS
, PINNED_OBJECTS
, CACHE_SIZE
, OPTIMAL_SIZE
, MAXIMUM_SIZE
, CON_ID
FROM SYS.GV_$SESSION_OBJECT_CACHE;
|
|
|