home - keyword index

Keyword: BLOCK

jump to Columns back to index

Tables

Table Name Description
GV$CR_BLOCK_SERVER Synonym for GV_$CR_BLOCK_SERVER
GV$DATABASE_BLOCK_CORRUPTION Synonym for GV_$DATABASE_BLOCK_CORRUPTION
GV$GES_BLOCKING_ENQUEUE Synonym for GV_$GES_BLOCKING_ENQUEUE
GV$GLOBAL_BLOCKED_LOCKS Synonym for GV_$GLOBAL_BLOCKED_LOCKS
V$CR_BLOCK_SERVER Synonym for V_$CR_BLOCK_SERVER
V$DATABASE_BLOCK_CORRUPTION Synonym for V_$DATABASE_BLOCK_CORRUPTION
V$GES_BLOCKING_ENQUEUE Synonym for V_$GES_BLOCKING_ENQUEUE
V$GLOBAL_BLOCKED_LOCKS Synonym for V_$GLOBAL_BLOCKED_LOCKS
top back to index

Columns

Column Name Description
ACTUAL_REDO_BLKS (GV$INSTANCE_RECOVERY)
ACTUAL_REDO_BLKS (V$INSTANCE_RECOVERY)
ASYNC_BLOCKS (V$ARCHIVE_DEST)
ASYNC_BLOCKS (GV$ARCHIVE_DEST)
AVG_BLOCKS_PER_KEY (CLU) Average number of blocks containing rows with a given cluster key
AVG_BLOCKS_PER_KEY (ALL_CLUSTERS) Average number of blocks containing rows with a given cluster key
AVG_BLOCKS_PER_KEY (USER_CLUSTERS) Average number of blocks containing rows with a given cluster key
AVG_BLOCKS_PER_KEY (DBA_CLUSTERS) Average number of blocks containing rows with a given cluster key
AVG_DATA_BLOCKS_PER_KEY (ALL_INDEXES) The average number of data blocks per key
AVG_DATA_BLOCKS_PER_KEY (DBA_INDEXES) The average number of data blocks per key
AVG_DATA_BLOCKS_PER_KEY (ALL_IND_SUBPARTITIONS)
AVG_DATA_BLOCKS_PER_KEY (USER_INDEXES) The average number of data blocks per key
AVG_DATA_BLOCKS_PER_KEY (DBA_IND_SUBPARTITIONS)
AVG_DATA_BLOCKS_PER_KEY (IND) The average number of data blocks per key
AVG_DATA_BLOCKS_PER_KEY (USER_IND_SUBPARTITIONS)
AVG_DATA_BLOCKS_PER_KEY (DBA_IND_PARTITIONS)
AVG_DATA_BLOCKS_PER_KEY (USER_IND_PARTITIONS)
AVG_DATA_BLOCKS_PER_KEY (ALL_IND_PARTITIONS)
AVG_LEAF_BLOCKS_PER_KEY (ALL_IND_PARTITIONS)
AVG_LEAF_BLOCKS_PER_KEY (USER_IND_SUBPARTITIONS)
AVG_LEAF_BLOCKS_PER_KEY (ALL_IND_SUBPARTITIONS)
AVG_LEAF_BLOCKS_PER_KEY (USER_INDEXES) The average number of leaf blocks per key
AVG_LEAF_BLOCKS_PER_KEY (IND) The average number of leaf blocks per key
AVG_LEAF_BLOCKS_PER_KEY (ALL_INDEXES) The average number of leaf blocks per key
AVG_LEAF_BLOCKS_PER_KEY (DBA_IND_SUBPARTITIONS)
AVG_LEAF_BLOCKS_PER_KEY (DBA_IND_PARTITIONS)
AVG_LEAF_BLOCKS_PER_KEY (DBA_INDEXES) The average number of leaf blocks per key
AVG_LEAF_BLOCKS_PER_KEY (USER_IND_PARTITIONS)
AVG_SPACE_FREELIST_BLOCKS (DBA_OBJECT_TABLES) The average freespace of all blocks on a freelist
AVG_SPACE_FREELIST_BLOCKS (USER_OBJECT_TABLES) The average freespace of all blocks on a freelist
AVG_SPACE_FREELIST_BLOCKS (ALL_TABLES) The average freespace of all blocks on a freelist
AVG_SPACE_FREELIST_BLOCKS (ALL_OBJECT_TABLES) The average freespace of all blocks on a freelist
AVG_SPACE_FREELIST_BLOCKS (DBA_ALL_TABLES) The average freespace of all blocks on a freelist
AVG_SPACE_FREELIST_BLOCKS (TABS) The average freespace of all blocks on a freelist
AVG_SPACE_FREELIST_BLOCKS (USER_TABLES) The average freespace of all blocks on a freelist
AVG_SPACE_FREELIST_BLOCKS (ALL_ALL_TABLES) The average freespace of all blocks on a freelist
AVG_SPACE_FREELIST_BLOCKS (DBA_TABLES) The average freespace of all blocks on a freelist
AVG_SPACE_FREELIST_BLOCKS (USER_ALL_TABLES) The average freespace of all blocks on a freelist
BLOCK (GV$_LOCK)
BLOCK (GV$ENQUEUE_LOCK)
BLOCK (V$ENQUEUE_LOCK)
BLOCK (V$_LOCK)
BLOCK (GV$TRANSACTION_ENQUEUE)
BLOCK (GV$LOCK)
BLOCK (DBA_LMT_USED_EXTENTS) Starting block number of the extent
BLOCK (V$LOCK)
BLOCK (V$TRANSACTION_ENQUEUE)
BLOCK (DBA_DMT_USED_EXTENTS) Starting block number of the extent
BLOCK# (GV$DATABASE_BLOCK_CORRUPTION)
BLOCK# (GV$BACKUP_CORRUPTION)
BLOCK# (GV$BH)
BLOCK# (GV$MANAGED_STANDBY)
BLOCK# (V$DATABASE_BLOCK_CORRUPTION)
BLOCK# (V$MANAGED_STANDBY)
BLOCK# (GV$COPY_CORRUPTION)
BLOCK# (V$COPY_CORRUPTION)
BLOCK# (V$BH)
BLOCK# (V$BACKUP_CORRUPTION)
BLOCKED (GV$DLM_LOCKS)
BLOCKED (V$GES_ENQUEUE)
BLOCKED (V$GES_BLOCKING_ENQUEUE)
BLOCKED (GV$GES_BLOCKING_ENQUEUE)
BLOCKED (GV$DLM_ALL_LOCKS)
BLOCKED (V$DLM_LOCKS)
BLOCKED (V$DLM_ALL_LOCKS)
BLOCKED (GV$GES_ENQUEUE)
BLOCKER (GV$DLM_ALL_LOCKS)
BLOCKER (V$DLM_LOCKS)
BLOCKER (V$GES_BLOCKING_ENQUEUE)
BLOCKER (GV$DLM_LOCKS)
BLOCKER (GV$GES_ENQUEUE)
BLOCKER (V$DLM_ALL_LOCKS)
BLOCKER (V$GES_ENQUEUE)
BLOCKER (GV$GES_BLOCKING_ENQUEUE)
BLOCKING_OTHERS (DBA_LOCKS)
BLOCKING_OTHERS (DBA_DML_LOCKS)
BLOCKING_OTHERS (DBA_LOCK)
BLOCKS (USER_SEGMENTS) Size, in Oracle blocks, of the segment
BLOCKS (V$TEMPSEG_USAGE)
BLOCKS (GV$DATAFILE_COPY)
BLOCKS (DBA_TAB_SUBPARTITIONS)
BLOCKS (USER_OBJECT_TABLES) The number of used blocks in the table
BLOCKS (GV$ARCHIVED_LOG)
BLOCKS (GV$TEMP_EXTENT_MAP)
BLOCKS (GV$SORT_USAGE)
BLOCKS (DBA_TAB_PARTITIONS)
BLOCKS (ALL_TAB_PARTITIONS)
BLOCKS (DBA_DMT_FREE_SPACE) Size of the extent in blocks
BLOCKS (GV$BACKUP_DATAFILE)
BLOCKS (V$DATAFILE_HEADER)
BLOCKS (V$ARCHIVED_LOG)
BLOCKS (V$TEMPFILE)
BLOCKS (V$COPY_CORRUPTION)
BLOCKS (V$PROXY_DATAFILE)
BLOCKS (DBA_EXTENTS) Size of the extent in ORACLE blocks
BLOCKS (V$MANAGED_STANDBY)
BLOCKS (DBA_TEMP_FILES) Size of the file in ORACLE blocks
BLOCKS (GV$BACKUP_CORRUPTION)
BLOCKS (ALL_ALL_TABLES) The number of used blocks in the table
BLOCKS (USER_ALL_TABLES) The number of used blocks in the table
BLOCKS (DBA_LMT_FREE_SPACE) Size of the extent in blocks
BLOCKS (V$DATAFILE_COPY)
BLOCKS (GV$DATABASE_BLOCK_CORRUPTION)
BLOCKS (GV$PROXY_DATAFILE)
BLOCKS (V$DATABASE_BLOCK_CORRUPTION)
BLOCKS (GV$COPY_CORRUPTION)
BLOCKS (GV$TEMPFILE)
BLOCKS (V$BACKUP_REDOLOG)
BLOCKS (DBA_TS_QUOTAS) Number of ORACLE blocks charged to the user
BLOCKS (USER_TAB_PARTITIONS)
BLOCKS (DBA_UNDO_EXTENTS) Size of the extent in ORACLE blocks
BLOCKS (V$TEMP_EXTENT_MAP)
BLOCKS (DBA_SEGMENTS) Size, in Oracle blocks, of the segment
BLOCKS (GV$DATAFILE)
BLOCKS (USER_TS_QUOTAS) Number of ORACLE blocks charged to the user
BLOCKS (DBA_OBJECT_TABLES) The number of used blocks in the table
BLOCKS (V$DATAFILE)
BLOCKS (V$BACKUP_CORRUPTION)
BLOCKS (ALL_TABLES) The number of used blocks in the table
BLOCKS (USER_FREE_SPACE) Size of the extent in ORACLE blocks
BLOCKS (V$BACKUP_DATAFILE)
BLOCKS (V$SORT_USAGE)
BLOCKS (GV$BACKUP_REDOLOG)
BLOCKS (USER_TAB_SUBPARTITIONS)
BLOCKS (DBA_ALL_TABLES) The number of used blocks in the table
BLOCKS (GV$PROXY_ARCHIVEDLOG)
BLOCKS (USER_EXTENTS) Size of the extent in ORACLE blocks
BLOCKS (ALL_OBJECT_TABLES) The number of used blocks in the table
BLOCKS (DBA_FREE_SPACE) Size of the extent in ORACLE blocks
BLOCKS (ALL_TAB_SUBPARTITIONS)
BLOCKS (DBA_TABLES) The number of used blocks in the table
BLOCKS (GV$MANAGED_STANDBY)
BLOCKS (GV$TEMPSEG_USAGE)
BLOCKS (V$PROXY_ARCHIVEDLOG)
BLOCKS (GV$DATAFILE_HEADER)
BLOCKS (DBA_DATA_FILES) Size of the file in ORACLE blocks
BLOCKS (TABS) The number of used blocks in the table
BLOCKS (USER_TABLES) The number of used blocks in the table
BLOCKS_CACHED (GV$TEMP_EXTENT_POOL)
BLOCKS_CACHED (V$TEMP_EXTENT_POOL)
BLOCKS_COALESCED (DBA_FREE_SPACE_COALESCED) Total Number of Coalesced Free Oracle Blocks in Tablespace
BLOCKS_COALESCED (DBA_FREE_SPACE_COALESCED_TMP1) Total Coalesced Free Oracle Blocks in Tablespace
BLOCKS_FREE (V$TEMP_SPACE_HEADER)
BLOCKS_FREE (GV$TEMP_SPACE_HEADER)
BLOCKS_USED (GV$TEMP_SPACE_HEADER)
BLOCKS_USED (V$TEMP_SPACE_HEADER)
BLOCKS_USED (GV$TEMP_EXTENT_POOL)
BLOCKS_USED (V$TEMP_EXTENT_POOL)
BLOCK_CHANGES (V$SESS_IO)
BLOCK_CHANGES (GV$SESS_IO)
BLOCK_COUNT (V$GC_ELEMENT)
BLOCK_COUNT (GV$GC_ELEMENT)
BLOCK_COUNT (V$LOCK_ELEMENT)
BLOCK_COUNT (GV$LOCK_ELEMENT)
BLOCK_GETS (GV$SESS_IO)
BLOCK_GETS (V$SESS_IO)
BLOCK_ID (DBA_LMT_FREE_SPACE) Starting block number of the extent
BLOCK_ID (DBA_FREE_SPACE) Starting block number of the extent
BLOCK_ID (DBA_ROLLBACK_SEGS) ID number of the block containing the segment header
BLOCK_ID (USER_FREE_SPACE) Starting block number of the extent
BLOCK_ID (V$TEMP_EXTENT_MAP)
BLOCK_ID (DBA_UNDO_EXTENTS) Starting block number of the extent
BLOCK_ID (GV$TEMP_EXTENT_MAP)
BLOCK_ID (DBA_EXTENTS) Starting block number of the extent
BLOCK_ID (DBA_DMT_FREE_SPACE) Starting block number of the extent
BLOCK_SIZE (V$DATAFILE_COPY)
BLOCK_SIZE (GV$BUFFER_POOL_STATISTICS)
BLOCK_SIZE (V$DATAFILE)
BLOCK_SIZE (V$PROXY_DATAFILE)
BLOCK_SIZE (GV$DATAFILE_COPY)
BLOCK_SIZE (DBA_TABLESPACES) Tablespace block size
BLOCK_SIZE (GV$ARCHIVED_LOG)
BLOCK_SIZE (V$BUFFER_POOL)
BLOCK_SIZE (GV$PROXY_ARCHIVEDLOG)
BLOCK_SIZE (GV$DB_CACHE_ADVICE)
BLOCK_SIZE (GV$TEMPFILE)
BLOCK_SIZE (GV$BACKUP_DATAFILE)
BLOCK_SIZE (V$BUFFER_POOL_STATISTICS)
BLOCK_SIZE (V$ARCHIVED_LOG)
BLOCK_SIZE (GV$BUFFER_POOL)
BLOCK_SIZE (GV$BACKUP_SET)
BLOCK_SIZE (GV$PROXY_DATAFILE)
BLOCK_SIZE (GV$BACKUP_REDOLOG)
BLOCK_SIZE (USER_TABLESPACES) Tablespace block size
BLOCK_SIZE (GV$DATAFILE)
BLOCK_SIZE (V$PROXY_ARCHIVEDLOG)
BLOCK_SIZE (V$BACKUP_SET)
BLOCK_SIZE (V$TEMPFILE)
BLOCK_SIZE (V$DB_CACHE_ADVICE)
BLOCK_SIZE (V$BACKUP_DATAFILE)
BLOCK_SIZE (V$BACKUP_REDOLOG)
CKPT_BLOCK_WRITES (GV$INSTANCE_RECOVERY)
CKPT_BLOCK_WRITES (V$INSTANCE_RECOVERY)
DATAFILE_BLOCKS (V$BACKUP_DATAFILE)
DATAFILE_BLOCKS (GV$BACKUP_DATAFILE)
DATA_BLK# (GV$LOGMNR_CONTENTS)
DATA_BLK# (V$LOGMNR_CONTENTS)
DB_BLOCK_CHANGE (GV$BUFFER_POOL_STATISTICS)
DB_BLOCK_CHANGE (V$BUFFER_POOL_STATISTICS)
DB_BLOCK_GETS (V$BUFFER_POOL_STATISTICS)
DB_BLOCK_GETS (GV$BUFFER_POOL_STATISTICS)
EMPTY_BLOCKS (ALL_OBJECT_TABLES) The number of empty (never used) blocks in the table
EMPTY_BLOCKS (USER_TABLES) The number of empty (never used) blocks in the table
EMPTY_BLOCKS (ALL_ALL_TABLES) The number of empty (never used) blocks in the table
EMPTY_BLOCKS (USER_TAB_SUBPARTITIONS)
EMPTY_BLOCKS (DBA_TAB_PARTITIONS)
EMPTY_BLOCKS (ALL_TAB_PARTITIONS)
EMPTY_BLOCKS (USER_ALL_TABLES) The number of empty (never used) blocks in the table
EMPTY_BLOCKS (DBA_ALL_TABLES) The number of empty (never used) blocks in the table
EMPTY_BLOCKS (ALL_TAB_SUBPARTITIONS)
EMPTY_BLOCKS (ALL_TABLES) The number of empty (never used) blocks in the table
EMPTY_BLOCKS (DBA_TABLES) The number of empty (never used) blocks in the table
EMPTY_BLOCKS (USER_TAB_PARTITIONS)
EMPTY_BLOCKS (DBA_TAB_SUBPARTITIONS)
EMPTY_BLOCKS (DBA_OBJECT_TABLES) The number of empty (never used) blocks in the table
EMPTY_BLOCKS (USER_OBJECT_TABLES) The number of empty (never used) blocks in the table
EMPTY_BLOCKS (TABS) The number of empty (never used) blocks in the table
FAIL_BLOCK (V$ARCHIVE_DEST)
FAIL_BLOCK (GV$ARCHIVE_DEST)
FAST_START_IO_TARGET_REDO_BLKS (V$INSTANCE_RECOVERY)
FAST_START_IO_TARGET_REDO_BLKS (GV$INSTANCE_RECOVERY)
FREE_BLOCKS (V$SORT_SEGMENT)
FREE_BLOCKS (GV$SORT_SEGMENT)
HEADER_BLOCK (DBA_SEGMENTS) ID of the block containing the segment header
LEAF_BLOCKS (DBA_IND_PARTITIONS)
LEAF_BLOCKS (ALL_IND_SUBPARTITIONS)
LEAF_BLOCKS (USER_INDEXES) The number of leaf blocks in the index
LEAF_BLOCKS (ALL_INDEXES) The number of leaf blocks in the index
LEAF_BLOCKS (DBA_INDEXES) The number of leaf blocks in the index
LEAF_BLOCKS (USER_IND_SUBPARTITIONS)
LEAF_BLOCKS (DBA_IND_SUBPARTITIONS)
LEAF_BLOCKS (IND) The number of leaf blocks in the index
LEAF_BLOCKS (USER_IND_PARTITIONS)
LEAF_BLOCKS (ALL_IND_PARTITIONS)
LOG_CHKPT_INTERVAL_REDO_BLKS (GV$INSTANCE_RECOVERY)
LOG_CHKPT_INTERVAL_REDO_BLKS (V$INSTANCE_RECOVERY)
LOG_CHKPT_TIMEOUT_REDO_BLKS (V$INSTANCE_RECOVERY)
LOG_CHKPT_TIMEOUT_REDO_BLKS (GV$INSTANCE_RECOVERY)
LOG_FILE_SIZE_REDO_BLKS (V$INSTANCE_RECOVERY)
LOG_FILE_SIZE_REDO_BLKS (GV$INSTANCE_RECOVERY)
MAX_BLOCKS (V$SORT_SEGMENT)
MAX_BLOCKS (DBA_TS_QUOTAS) User's quota in ORACLE blocks. NULL if no limit
MAX_BLOCKS (USER_TS_QUOTAS) User's quota in ORACLE blocks. NULL if no limit
MAX_BLOCKS (GV$SORT_SEGMENT)
MAX_SORT_BLOCKS (GV$SORT_SEGMENT)
MAX_SORT_BLOCKS (V$SORT_SEGMENT)
MAX_USED_BLOCKS (GV$SORT_SEGMENT)
MAX_USED_BLOCKS (V$SORT_SEGMENT)
NUM_FREELIST_BLOCKS (ALL_TABLES) The number of blocks on the freelist
NUM_FREELIST_BLOCKS (ALL_ALL_TABLES) The number of blocks on the freelist
NUM_FREELIST_BLOCKS (USER_ALL_TABLES) The number of blocks on the freelist
NUM_FREELIST_BLOCKS (USER_TABLES) The number of blocks on the freelist
NUM_FREELIST_BLOCKS (ALL_OBJECT_TABLES) The number of blocks on the freelist
NUM_FREELIST_BLOCKS (DBA_OBJECT_TABLES) The number of blocks on the freelist
NUM_FREELIST_BLOCKS (TABS) The number of blocks on the freelist
NUM_FREELIST_BLOCKS (DBA_TABLES) The number of blocks on the freelist
NUM_FREELIST_BLOCKS (DBA_ALL_TABLES) The number of blocks on the freelist
NUM_FREELIST_BLOCKS (USER_OBJECT_TABLES) The number of blocks on the freelist
PERCENT_BLOCKS_COALESCED (DBA_FREE_SPACE_COALESCED) Percentage of Coalesced Free Oracle Blocks in Tablespace
ROW_WAIT_BLOCK# (GV$SESSION)
ROW_WAIT_BLOCK# (V$SESSION)
SEGMENT_BLOCK (DBA_LMT_USED_EXTENTS) Block number of segment header of the extent
SEGMENT_BLOCK (V$SORT_SEGMENT)
SEGMENT_BLOCK (DBA_DMT_USED_EXTENTS) Block number of segment header of the extent
SEGMENT_BLOCK (GV$SORT_SEGMENT)
TARGET_REDO_BLKS (V$INSTANCE_RECOVERY)
TARGET_REDO_BLKS (GV$INSTANCE_RECOVERY)
TOTAL_BLOCKS (GV$SORT_SEGMENT)
TOTAL_BLOCKS (DBA_FREE_SPACE_COALESCED) Total Number of Free Oracle Blocks in Tablespace
TOTAL_BLOCKS (DBA_FREE_SPACE_COALESCED_TMP3) Total Free Blocks in Tablespace
TOTAL_BLOCKS (DBA_FREE_SPACE_COALESCED_TMP2) Total Free Blocks in Tablespace
TOTAL_BLOCKS (V$SORT_SEGMENT)
USED_BLOCKS (GV$SORT_SEGMENT)
USED_BLOCKS (V$SORT_SEGMENT)
USER_BLOCKS (DBA_DATA_FILES) Size of the useful portion of file in ORACLE blocks
USER_BLOCKS (DBA_TEMP_FILES) Size of the useful portion of file in ORACLE blocks
VALUE_BLK (GV$DLM_RESS)
VALUE_BLK (V$DLM_RESS)
VALUE_BLK_STATE (GV$DLM_RESS)
VALUE_BLK_STATE (V$DLM_RESS)
top back to index

Comment on this page:




home - keyword index