Keyword: BUFFER
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| GV$BUFFER_POOL | Synonym for GV_$BUFFER_POOL |
| GV$BUFFER_POOL_STATISTICS | Synonym for GV_$BUFFER_POOL_STATISTICS |
| V$BUFFER_POOL | Synonym for V_$BUFFER_POOL |
| V$BUFFER_POOL_STATISTICS | Synonym for V_$BUFFER_POOL_STATISTICS |
Columns
| Column Name | Description |
|---|---|
| AVG_BUF_RATE (V$DISPATCHER_RATE) | |
| AVG_BUF_RATE (GV$DISPATCHER_RATE) | |
| AVG_BYTE_PER_BUF (V$DISPATCHER_RATE) | |
| AVG_BYTE_PER_BUF (GV$DISPATCHER_RATE) | |
| AVG_CLT_BUF_RATE (GV$DISPATCHER_RATE) | |
| AVG_CLT_BUF_RATE (V$DISPATCHER_RATE) | |
| AVG_CLT_BYTE_PER_BUF (GV$DISPATCHER_RATE) | |
| AVG_CLT_BYTE_PER_BUF (V$DISPATCHER_RATE) | |
| AVG_SVR_BUF_RATE (GV$DISPATCHER_RATE) | |
| AVG_SVR_BUF_RATE (V$DISPATCHER_RATE) | |
| AVG_SVR_BYTE_PER_BUF (V$DISPATCHER_RATE) | |
| AVG_SVR_BYTE_PER_BUF (GV$DISPATCHER_RATE) | |
| BUFFERS (GV$BUFFER_POOL) | |
| BUFFERS (V$BUFFER_POOL) | |
| BUFFERS_FOR_ESTIMATE (V$DB_CACHE_ADVICE) | |
| BUFFERS_FOR_ESTIMATE (GV$DB_CACHE_ADVICE) | |
| BUFFER_BUSY_WAIT (V$BUFFER_POOL_STATISTICS) | |
| BUFFER_BUSY_WAIT (GV$BUFFER_POOL_STATISTICS) | |
| BUFFER_COUNT (GV$BACKUP_SYNC_IO) | |
| BUFFER_COUNT (GV$BACKUP_ASYNC_IO) | |
| BUFFER_COUNT (V$BACKUP_ASYNC_IO) | |
| BUFFER_COUNT (V$BACKUP_SYNC_IO) | |
| BUFFER_GETS (V$SQLXS) | |
| BUFFER_GETS (V$SQLAREA) | |
| BUFFER_GETS (GV$SQLAREA) | |
| BUFFER_GETS (V$SQL) | |
| BUFFER_GETS (GV$SQL) | |
| BUFFER_POOL (USER_IND_SUBPARTITIONS) | |
| BUFFER_POOL (DBA_INDEXES) | The default buffer pool to be used for index blocks |
| BUFFER_POOL (ALL_TABLES) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (ALL_TAB_SUBPARTITIONS) | |
| BUFFER_POOL (ALL_IND_SUBPARTITIONS) | |
| BUFFER_POOL (TABS) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (USER_CLUSTERS) | The default buffer pool to be used for cluster blocks |
| BUFFER_POOL (USER_LOB_PARTITIONS) | |
| BUFFER_POOL (DBA_TABLES) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (USER_IND_PARTITIONS) | |
| BUFFER_POOL (USER_OBJECT_TABLES) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (DBA_TAB_SUBPARTITIONS) | |
| BUFFER_POOL (ALL_CLUSTERS) | The default buffer pool to be used for cluster blocks |
| BUFFER_POOL (DBA_IND_PARTITIONS) | |
| BUFFER_POOL (DBA_TAB_PARTITIONS) | |
| BUFFER_POOL (ALL_ALL_TABLES) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (ALL_INDEXES) | The default buffer pool to be used for index blocks |
| BUFFER_POOL (USER_INDEXES) | The default buffer pool to be used for index blocks |
| BUFFER_POOL (ALL_IND_PARTITIONS) | |
| BUFFER_POOL (USER_LOB_SUBPARTITIONS) | |
| BUFFER_POOL (USER_ALL_TABLES) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (IND) | The default buffer pool to be used for index blocks |
| BUFFER_POOL (DBA_LOB_PARTITIONS) | |
| BUFFER_POOL (USER_TABLES) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (USER_TAB_PARTITIONS) | |
| BUFFER_POOL (DBA_OBJECT_TABLES) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (DBA_ALL_TABLES) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (CLU) | The default buffer pool to be used for cluster blocks |
| BUFFER_POOL (DBA_CLUSTERS) | The default buffer pool to be used for cluster blocks |
| BUFFER_POOL (USER_TAB_SUBPARTITIONS) | |
| BUFFER_POOL (DBA_LOB_SUBPARTITIONS) | |
| BUFFER_POOL (DBA_SEGMENTS) | The default buffer pool to be used for segments blocks |
| BUFFER_POOL (ALL_LOB_PARTITIONS) | |
| BUFFER_POOL (ALL_OBJECT_TABLES) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (ALL_TAB_PARTITIONS) | |
| BUFFER_POOL (ALL_LOB_SUBPARTITIONS) | |
| BUFFER_POOL (DBA_IND_SUBPARTITIONS) | |
| BUFFER_POOL (USER_SEGMENTS) | The default buffer pool to be used for blocks from this segment |
| BUFFER_SIZE (GV$BACKUP_SYNC_IO) | |
| BUFFER_SIZE (GV$BACKUP_ASYNC_IO) | |
| BUFFER_SIZE (V$BACKUP_SYNC_IO) | |
| BUFFER_SIZE (V$BACKUP_ASYNC_IO) | |
| BUF_ADDRESS (V$SQL_BIND_DATA) | |
| BUF_ADDRESS (GV$SQL_BIND_DATA) | |
| BUF_FLAG (GV$SQL_BIND_DATA) | |
| BUF_FLAG (V$SQL_BIND_DATA) | |
| BUF_GOT (V$BUFFER_POOL_STATISTICS) | |
| BUF_GOT (GV$BUFFER_POOL_STATISTICS) | |
| BUF_LENGTH (V$SQL_BIND_DATA) | |
| BUF_LENGTH (GV$SQL_BIND_DATA) | |
| CR_BUFFER_GETS (GV$SQL_PLAN_STATISTICS_ALL) | |
| CR_BUFFER_GETS (V$SQL_PLAN_STATISTICS) | |
| CR_BUFFER_GETS (V$SQL_PLAN_STATISTICS_ALL) | |
| CR_BUFFER_GETS (GV$SQL_PLAN_STATISTICS) | |
| CUR_BUF_RATE (GV$DISPATCHER_RATE) | |
| CUR_BUF_RATE (V$DISPATCHER_RATE) | |
| CUR_BYTE_PER_BUF (V$DISPATCHER_RATE) | |
| CUR_BYTE_PER_BUF (GV$DISPATCHER_RATE) | |
| CUR_CLT_BUF_RATE (V$DISPATCHER_RATE) | |
| CUR_CLT_BUF_RATE (GV$DISPATCHER_RATE) | |
| CUR_CLT_BYTE_PER_BUF (V$DISPATCHER_RATE) | |
| CUR_CLT_BYTE_PER_BUF (GV$DISPATCHER_RATE) | |
| CUR_SVR_BUF_RATE (V$DISPATCHER_RATE) | |
| CUR_SVR_BUF_RATE (GV$DISPATCHER_RATE) | |
| CUR_SVR_BYTE_PER_BUF (V$DISPATCHER_RATE) | |
| CUR_SVR_BYTE_PER_BUF (GV$DISPATCHER_RATE) | |
| CU_BUFFER_GETS (GV$SQL_PLAN_STATISTICS) | |
| CU_BUFFER_GETS (V$SQL_PLAN_STATISTICS_ALL) | |
| CU_BUFFER_GETS (V$SQL_PLAN_STATISTICS) | |
| CU_BUFFER_GETS (GV$SQL_PLAN_STATISTICS_ALL) | |
| DEF_BUFFER_POOL (ALL_PART_INDEXES) | |
| DEF_BUFFER_POOL (DBA_PART_INDEXES) | |
| DEF_BUFFER_POOL (DBA_PART_LOBS) | |
| DEF_BUFFER_POOL (ALL_PART_TABLES) | |
| DEF_BUFFER_POOL (DBA_PART_TABLES) | |
| DEF_BUFFER_POOL (USER_PART_LOBS) | |
| DEF_BUFFER_POOL (ALL_PART_LOBS) | |
| DEF_BUFFER_POOL (USER_PART_INDEXES) | |
| DEF_BUFFER_POOL (USER_PART_TABLES) | |
| DIRTY_BUFFERS_INSPECTED (V$BUFFER_POOL_STATISTICS) | |
| DIRTY_BUFFERS_INSPECTED (GV$BUFFER_POOL_STATISTICS) | |
| FREE_BUFFER_INSPECTED (GV$BUFFER_POOL_STATISTICS) | |
| FREE_BUFFER_INSPECTED (V$BUFFER_POOL_STATISTICS) | |
| FREE_BUFFER_WAIT (GV$BUFFER_POOL_STATISTICS) | |
| FREE_BUFFER_WAIT (V$BUFFER_POOL_STATISTICS) | |
| LAST_CR_BUFFER_GETS (V$SQL_PLAN_STATISTICS_ALL) | |
| LAST_CR_BUFFER_GETS (V$SQL_PLAN_STATISTICS) | |
| LAST_CR_BUFFER_GETS (GV$SQL_PLAN_STATISTICS) | |
| LAST_CR_BUFFER_GETS (GV$SQL_PLAN_STATISTICS_ALL) | |
| LAST_CU_BUFFER_GETS (V$SQL_PLAN_STATISTICS) | |
| LAST_CU_BUFFER_GETS (GV$SQL_PLAN_STATISTICS_ALL) | |
| LAST_CU_BUFFER_GETS (GV$SQL_PLAN_STATISTICS) | |
| LAST_CU_BUFFER_GETS (V$SQL_PLAN_STATISTICS_ALL) | |
| MAX_BUF_RATE (V$DISPATCHER_RATE) | |
| MAX_BUF_RATE (GV$DISPATCHER_RATE) | |
| MAX_BYTE_PER_BUF (GV$DISPATCHER_RATE) | |
| MAX_BYTE_PER_BUF (V$DISPATCHER_RATE) | |
| MAX_CLT_BUF_RATE (V$DISPATCHER_RATE) | |
| MAX_CLT_BUF_RATE (GV$DISPATCHER_RATE) | |
| MAX_CLT_BYTE_PER_BUF (GV$DISPATCHER_RATE) | |
| MAX_CLT_BYTE_PER_BUF (V$DISPATCHER_RATE) | |
| MAX_SVR_BUF_RATE (GV$DISPATCHER_RATE) | |
| MAX_SVR_BUF_RATE (V$DISPATCHER_RATE) | |
| MAX_SVR_BYTE_PER_BUF (V$DISPATCHER_RATE) | |
| MAX_SVR_BYTE_PER_BUF (GV$DISPATCHER_RATE) | |
| PREV_BUFFERS (GV$BUFFER_POOL) | |
| PREV_BUFFERS (V$BUFFER_POOL) | |
| SCALE_BUF (V$DISPATCHER_RATE) | |
| SCALE_BUF (GV$DISPATCHER_RATE) | |
| SCALE_CLT_BUF (V$DISPATCHER_RATE) | |
| SCALE_CLT_BUF (GV$DISPATCHER_RATE) | |
| SCALE_SVR_BUF (GV$DISPATCHER_RATE) | |
| SCALE_SVR_BUF (V$DISPATCHER_RATE) | |
| TARGET_BUFFERS (V$BUFFER_POOL) | |
| TARGET_BUFFERS (GV$BUFFER_POOL) | |
| TTL_BUF (GV$DISPATCHER_RATE) | |
| TTL_BUF (V$DISPATCHER_RATE) | |
| TTL_CLT_BUF (V$DISPATCHER_RATE) | |
| TTL_CLT_BUF (GV$DISPATCHER_RATE) | |
| TTL_SVR_BUF (V$DISPATCHER_RATE) | |
| TTL_SVR_BUF (GV$DISPATCHER_RATE) |