Keyword: CACHE
jump to Columns back to indexTables
Table Name | Description |
---|---|
GV$CLASS_CACHE_TRANSFER | Synonym for GV_$CLASS_CACHE_TRANSFER |
GV$DB_CACHE_ADVICE | Synonym for GV_$DB_CACHE_ADVICE |
GV$DB_OBJECT_CACHE | Synonym for GV_$DB_OBJECT_CACHE |
GV$FILE_CACHE_TRANSFER | Synonym for GV_$FILE_CACHE_TRANSFER |
GV$LIBRARY_CACHE_MEMORY | Synonym for GV_$LIBRARY_CACHE_MEMORY |
GV$SESSION_CURSOR_CACHE | Synonym for GV_$SESSION_CURSOR_CACHE |
GV$SESSION_OBJECT_CACHE | Synonym for GV_$SESSION_OBJECT_CACHE |
GV$SYSTEM_CURSOR_CACHE | Synonym for GV_$SYSTEM_CURSOR_CACHE |
GV$TEMP_CACHE_TRANSFER | Synonym for GV_$TEMP_CACHE_TRANSFER |
V$CLASS_CACHE_TRANSFER | Synonym for V_$CLASS_CACHE_TRANSFER |
V$DB_CACHE_ADVICE | Synonym for V_$DB_CACHE_ADVICE |
V$DB_OBJECT_CACHE | Synonym for V_$DB_OBJECT_CACHE |
V$FILE_CACHE_TRANSFER | Synonym for V_$FILE_CACHE_TRANSFER |
V$LIBRARY_CACHE_MEMORY | Synonym for V_$LIBRARY_CACHE_MEMORY |
V$SESSION_CURSOR_CACHE | Synonym for V_$SESSION_CURSOR_CACHE |
V$SESSION_OBJECT_CACHE | Synonym for V_$SESSION_OBJECT_CACHE |
V$SYSTEM_CURSOR_CACHE | Synonym for V_$SYSTEM_CURSOR_CACHE |
V$TEMP_CACHE_TRANSFER | Synonym for V_$TEMP_CACHE_TRANSFER |
Columns
Column Name | Description |
---|---|
AGGREGATE_CACHE_HITS (GV$AW_CALC) | |
AGGREGATE_CACHE_HITS (V$AW_CALC) | |
AGGREGATE_CACHE_MISSES (V$AW_CALC) | |
AGGREGATE_CACHE_MISSES (GV$AW_CALC) | |
BLOCKS_CACHED (V$TEMP_EXTENT_POOL) | |
BLOCKS_CACHED (GV$TEMP_EXTENT_POOL) | |
BYTES_CACHED (V$TEMP_EXTENT_POOL) | |
BYTES_CACHED (GV$TEMP_EXTENT_POOL) | |
CACHE (ALL_TABLES) | Whether the table is to be cached in the buffer cache |
CACHE (TABS) | Whether the table is to be cached in the buffer cache |
CACHE (USER_LOBS) | Is the LOB accessed through the buffer cache? |
CACHE (USER_LOB_SUBPARTITIONS) | |
CACHE (USER_TABLES) | Whether the table is to be cached in the buffer cache |
CACHE (USER_CLUSTERS) | Whether the cluster is to be cached in the buffer cache |
CACHE (USER_LOB_PARTITIONS) | |
CACHE (USER_OBJECT_TABLES) | Whether the table is to be cached in the buffer cache |
CACHE (ALL_CLUSTERS) | Whether the cluster is to be cached in the buffer cache |
CACHE (DBA_OBJECT_TABLES) | Whether the table is to be cached in the buffer cache |
CACHE (CLU) | Whether the cluster is to be cached in the buffer cache |
CACHE (DBA_CLUSTERS) | Whether the cluster is to be cached in the buffer cache |
CACHE (ALL_OBJECT_TABLES) | Whether the table is to be cached in the buffer cache |
CACHE (ALL_LOB_SUBPARTITIONS) | |
CACHE (DBA_ALL_TABLES) | Whether the table is to be cached in the buffer cache |
CACHE (ALL_LOB_PARTITIONS) | |
CACHE (DBA_LOB_SUBPARTITIONS) | |
CACHE (ALL_ALL_TABLES) | Whether the table is to be cached in the buffer cache |
CACHE (DBA_TABLES) | Whether the table is to be cached in the buffer cache |
CACHE (ALL_LOBS) | Is the LOB accessed through the buffer cache? |
CACHE (DBA_LOB_PARTITIONS) | |
CACHE (USER_ALL_TABLES) | Whether the table is to be cached in the buffer cache |
CACHE (DBA_LOBS) | Is the LOB accessed through the buffer cache? |
CACHE# (GV$ROWCACHE_SUBORDINATE) | |
CACHE# (V$ROWCACHE_SUBORDINATE) | |
CACHE# (V$ROWCACHE) | |
CACHE# (GV$ROWCACHE_PARENT) | |
CACHE# (V$ROWCACHE_PARENT) | |
CACHE# (GV$ROWCACHE) | |
CACHED_OBJECTS (V$SESSION_OBJECT_CACHE) | |
CACHED_OBJECTS (GV$SESSION_OBJECT_CACHE) | |
CACHE_CNT (GV$SUBCACHE) | |
CACHE_CNT (V$SUBCACHE) | |
CACHE_FLUSHES (GV$SESSION_OBJECT_CACHE) | |
CACHE_FLUSHES (V$SESSION_OBJECT_CACHE) | |
CACHE_ID (V$SUBCACHE) | |
CACHE_ID (GV$SUBCACHE) | |
CACHE_LOBS (GV$TEMPORARY_LOBS) | |
CACHE_LOBS (V$TEMPORARY_LOBS) | |
CACHE_NAME (GV$ROWCACHE_PARENT) | |
CACHE_NAME (V$ROWCACHE_PARENT) | |
CACHE_REFRESHES (V$SESSION_OBJECT_CACHE) | |
CACHE_REFRESHES (GV$SESSION_OBJECT_CACHE) | |
CACHE_SHRINKS (GV$SESSION_OBJECT_CACHE) | |
CACHE_SHRINKS (V$SESSION_OBJECT_CACHE) | |
CACHE_SIZE (ALL_SEQUENCES) | Number of sequence numbers to cache |
CACHE_SIZE (DBA_SEQUENCES) | Number of sequence numbers to cache |
CACHE_SIZE (SEQ) | Number of sequence numbers to cache |
CACHE_SIZE (V$SESSION_OBJECT_CACHE) | |
CACHE_SIZE (GV$SESSION_OBJECT_CACHE) | |
CACHE_SIZE (USER_SEQUENCES) | Number of sequence numbers to cache |
CACHE_WRITES (V$AW_CALC) | |
CACHE_WRITES (GV$AW_CALC) | |
DEF_CACHE (DBA_PART_LOBS) | |
DEF_CACHE (USER_PART_LOBS) | |
DEF_CACHE (ALL_PART_LOBS) | |
ESTD_CACHE_WRITES (GV$MTTR_TARGET_ADVICE) | |
ESTD_CACHE_WRITES (V$MTTR_TARGET_ADVICE) | |
ESTD_CACHE_WRITE_FACTOR (GV$MTTR_TARGET_ADVICE) | |
ESTD_CACHE_WRITE_FACTOR (V$MTTR_TARGET_ADVICE) | |
ESTD_PGA_CACHE_HIT_PERCENTAGE (V$PGA_TARGET_ADVICE) | |
ESTD_PGA_CACHE_HIT_PERCENTAGE (GV$PGA_TARGET_ADVICE) | |
EXTENTS_CACHED (GV$TEMP_EXTENT_POOL) | |
EXTENTS_CACHED (V$TEMP_EXTENT_POOL) | |
SESSION_CACHE_HITS (GV$AW_CALC) | |
SESSION_CACHE_HITS (V$AW_CALC) | |
SESSION_CACHE_MISSES (GV$AW_CALC) | |
SESSION_CACHE_MISSES (V$AW_CALC) |