Keyword: POOL
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| GV$ACTIVE_SESS_POOL_MTH | Synonym for GV_$ACTIVE_SESS_POOL_MTH |
| GV$BUFFER_POOL | Synonym for GV_$BUFFER_POOL |
| GV$BUFFER_POOL_STATISTICS | Synonym for GV_$BUFFER_POOL_STATISTICS |
| GV$SHARED_POOL_ADVICE | Synonym for GV_$SHARED_POOL_ADVICE |
| GV$SHARED_POOL_RESERVED | Synonym for GV_$SHARED_POOL_RESERVED |
| GV$TEMP_EXTENT_POOL | Synonym for GV_$TEMP_EXTENT_POOL |
| V$ACTIVE_SESS_POOL_MTH | Synonym for V_$ACTIVE_SESS_POOL_MTH |
| V$BUFFER_POOL | Synonym for V_$BUFFER_POOL |
| V$BUFFER_POOL_STATISTICS | Synonym for V_$BUFFER_POOL_STATISTICS |
| V$SHARED_POOL_ADVICE | Synonym for V_$SHARED_POOL_ADVICE |
| V$SHARED_POOL_RESERVED | Synonym for V_$SHARED_POOL_RESERVED |
| V$TEMP_EXTENT_POOL | Synonym for V_$TEMP_EXTENT_POOL |
Columns
| Column Name | Description |
|---|---|
| ACTIVE_SESS_POOL_MTH (DBA_RSRC_PLANS) | maximum active sessions target resource allocation method for the plan |
| ACTIVE_SESS_POOL_P1 (DBA_RSRC_PLAN_DIRECTIVES) | first parameter for the maximum active sessions target resource allocation method |
| BUFFER_POOL (ALL_CLUSTERS) | The default buffer pool to be used for cluster blocks |
| BUFFER_POOL (DBA_INDEXES) | The default buffer pool to be used for index blocks |
| BUFFER_POOL (ALL_LOB_SUBPARTITIONS) | |
| BUFFER_POOL (ALL_TABLES) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (USER_INDEXES) | The default buffer pool to be used for index blocks |
| BUFFER_POOL (USER_IND_SUBPARTITIONS) | |
| BUFFER_POOL (USER_IND_PARTITIONS) | |
| BUFFER_POOL (DBA_TABLES) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (TABS) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (ALL_IND_SUBPARTITIONS) | |
| BUFFER_POOL (ALL_INDEXES) | The default buffer pool to be used for index blocks |
| BUFFER_POOL (USER_LOB_SUBPARTITIONS) | |
| BUFFER_POOL (IND) | The default buffer pool to be used for index blocks |
| BUFFER_POOL (USER_CLUSTERS) | The default buffer pool to be used for cluster blocks |
| BUFFER_POOL (USER_LOB_PARTITIONS) | |
| BUFFER_POOL (USER_OBJECT_TABLES) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (DBA_TAB_SUBPARTITIONS) | |
| BUFFER_POOL (USER_SEGMENTS) | The default buffer pool to be used for blocks from this segment |
| BUFFER_POOL (DBA_IND_PARTITIONS) | |
| BUFFER_POOL (DBA_TAB_PARTITIONS) | |
| BUFFER_POOL (ALL_TAB_PARTITIONS) | |
| BUFFER_POOL (ALL_IND_PARTITIONS) | |
| BUFFER_POOL (USER_ALL_TABLES) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (ALL_OBJECT_TABLES) | The default buffer pool to be used for table blocks |
| BUFFER_POOL (DBA_LOB_PARTITIONS) | |
| BUFFER_POOL (ALL_ALL_TABLES) | The default buffer pool to be used for table blocks |
| 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 (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 (DBA_IND_SUBPARTITIONS) | |
| 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 (ALL_TAB_SUBPARTITIONS) | |
| DEF_BUFFER_POOL (DBA_PART_TABLES) | |
| DEF_BUFFER_POOL (DBA_PART_INDEXES) | |
| DEF_BUFFER_POOL (USER_PART_TABLES) | |
| DEF_BUFFER_POOL (ALL_PART_INDEXES) | |
| DEF_BUFFER_POOL (ALL_PART_TABLES) | |
| DEF_BUFFER_POOL (USER_PART_INDEXES) | |
| DEF_BUFFER_POOL (ALL_PART_LOBS) | |
| DEF_BUFFER_POOL (DBA_PART_LOBS) | |
| DEF_BUFFER_POOL (USER_PART_LOBS) | |
| MEDIA_POOL (V$PROXY_ARCHIVEDLOG) | |
| MEDIA_POOL (GV$BACKUP_PIECE) | |
| MEDIA_POOL (V$BACKUP_PIECE) | |
| MEDIA_POOL (V$PROXY_DATAFILE) | |
| MEDIA_POOL (GV$PROXY_DATAFILE) | |
| MEDIA_POOL (GV$PROXY_ARCHIVEDLOG) | |
| POOL (V$SGASTAT) | |
| POOL (GV$SGASTAT) | |
| POOL_CHANGED_PAGES (V$AW_OLAP) | |
| POOL_CHANGED_PAGES (GV$AW_OLAP) | |
| POOL_HITS (GV$AW_CALC) | |
| POOL_HITS (V$AW_CALC) | |
| POOL_MISSES (V$AW_CALC) | |
| POOL_MISSES (GV$AW_CALC) | |
| POOL_NEW_PAGES (GV$AW_CALC) | |
| POOL_NEW_PAGES (V$AW_CALC) | |
| POOL_RECLAIMED_PAGES (V$AW_CALC) | |
| POOL_RECLAIMED_PAGES (GV$AW_CALC) | |
| POOL_SIZE (V$AW_CALC) | |
| POOL_SIZE (GV$AW_CALC) | |
| POOL_UNCHANGED_PAGES (V$AW_OLAP) | |
| POOL_UNCHANGED_PAGES (GV$AW_OLAP) | |
| SHARED_POOL_SIZE_FACTOR (GV$SHARED_POOL_ADVICE) | |
| SHARED_POOL_SIZE_FACTOR (V$SHARED_POOL_ADVICE) | |
| SHARED_POOL_SIZE_FOR_ESTIMATE (GV$SHARED_POOL_ADVICE) | |
| SHARED_POOL_SIZE_FOR_ESTIMATE (V$SHARED_POOL_ADVICE) | |
| UNDO_POOL (DBA_RSRC_PLAN_DIRECTIVES) | max. undo allocation for consumer groups |