Keyword: BLOCK
jump to Columns back to indexTables
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 |
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) |