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) |