| Column Name
| Description
|
| ARRAY_SIZE (V$SQL_BIND_DATA)
|
|
| ARRAY_SIZE (GV$SQL_BIND_DATA)
|
|
| AVG_FREE_SIZE (V$SHARED_POOL_RESERVED)
|
|
| AVG_FREE_SIZE (GV$SHARED_POOL_RESERVED)
|
|
| AVG_SIZE (USER_QUEUE_SCHEDULES)
|
|
| AVG_SIZE (DBA_QUEUE_SCHEDULES)
|
|
| AVG_USED_SIZE (GV$SHARED_POOL_RESERVED)
|
|
| AVG_USED_SIZE (V$SHARED_POOL_RESERVED)
|
|
| BLOCK_SIZE (V$BACKUP_REDOLOG)
|
|
| BLOCK_SIZE (V$DATAFILE_COPY)
|
|
| BLOCK_SIZE (GV$BUFFER_POOL_STATISTICS)
|
|
| BLOCK_SIZE (V$BACKUP_DATAFILE)
|
|
| BLOCK_SIZE (GV$PROXY_DATAFILE)
|
|
| BLOCK_SIZE (GV$DATAFILE)
|
|
| BLOCK_SIZE (V$PROXY_ARCHIVEDLOG)
|
|
| BLOCK_SIZE (V$BACKUP_SET)
|
|
| BLOCK_SIZE (GV$TEMPFILE)
|
|
| BLOCK_SIZE (V$DATAFILE)
|
|
| BLOCK_SIZE (V$BUFFER_POOL_STATISTICS)
|
|
| BLOCK_SIZE (V$PROXY_DATAFILE)
|
|
| BLOCK_SIZE (DBA_TABLESPACES)
| Tablespace block size
|
| BLOCK_SIZE (GV$BUFFER_POOL)
|
|
| BLOCK_SIZE (GV$ARCHIVED_LOG)
|
|
| BLOCK_SIZE (USER_TABLESPACES)
| Tablespace block size
|
| BLOCK_SIZE (GV$PROXY_ARCHIVEDLOG)
|
|
| BLOCK_SIZE (GV$DATAFILE_COPY)
|
|
| BLOCK_SIZE (GV$BACKUP_REDOLOG)
|
|
| BLOCK_SIZE (GV$DB_CACHE_ADVICE)
|
|
| BLOCK_SIZE (GV$BACKUP_DATAFILE)
|
|
| BLOCK_SIZE (V$BUFFER_POOL)
|
|
| BLOCK_SIZE (GV$BACKUP_SET)
|
|
| BLOCK_SIZE (V$TEMPFILE)
|
|
| BLOCK_SIZE (V$ARCHIVED_LOG)
|
|
| BLOCK_SIZE (V$DB_CACHE_ADVICE)
|
|
| BUFFER_SIZE (GV$BACKUP_SYNC_IO)
|
|
| BUFFER_SIZE (V$BACKUP_SYNC_IO)
|
|
| BUFFER_SIZE (GV$BACKUP_ASYNC_IO)
|
|
| BUFFER_SIZE (V$BACKUP_ASYNC_IO)
|
|
| CACHE_SIZE (USER_SEQUENCES)
| Number of sequence numbers to cache
|
| CACHE_SIZE (ALL_SEQUENCES)
| Number of sequence numbers to cache
|
| CACHE_SIZE (V$SESSION_OBJECT_CACHE)
|
|
| CACHE_SIZE (DBA_SEQUENCES)
| Number of sequence numbers to cache
|
| CACHE_SIZE (SEQ)
| Number of sequence numbers to cache
|
| CACHE_SIZE (GV$SESSION_OBJECT_CACHE)
|
|
| CHUNK_SIZE (GV$SQL_SHARED_MEMORY)
|
|
| CHUNK_SIZE (V$SQL_SHARED_MEMORY)
|
|
| CODE_SIZE (DBA_OBJECT_SIZE)
| Code size, in bytes. Must be in memory when this object is executing
|
| CODE_SIZE (USER_OBJECT_SIZE)
| Code size, in bytes. Must be in memory when this object is executing
|
| CURRENT_SIZE (V$SGA_DYNAMIC_COMPONENTS)
|
|
| CURRENT_SIZE (V$BUFFER_POOL)
|
|
| CURRENT_SIZE (GV$SGA_CURRENT_RESIZE_OPS)
|
|
| CURRENT_SIZE (GV$SGA_DYNAMIC_COMPONENTS)
|
|
| CURRENT_SIZE (V$SGA_CURRENT_RESIZE_OPS)
|
|
| CURRENT_SIZE (GV$SGA_DYNAMIC_FREE_MEMORY)
|
|
| CURRENT_SIZE (GV$BUFFER_POOL)
|
|
| CURRENT_SIZE (V$SGA_DYNAMIC_FREE_MEMORY)
|
|
| CU_SIZE (GV$MAP_FILE_IO_STACK)
|
|
| CU_SIZE (V$MAP_FILE_IO_STACK)
|
|
| ELEM_SIZE (V$MAP_ELEMENT)
|
|
| ELEM_SIZE (GV$MAP_ELEMENT)
|
|
| ERROR_SIZE (DBA_OBJECT_SIZE)
| Size of error messages, in bytes. In memory during the compilation of the object when there are compilation errors
|
| ERROR_SIZE (USER_OBJECT_SIZE)
| Size of error messages, in bytes. In memory during the compilation of the object when there are compilation errors
|
| ESTD_LC_SIZE (GV$SHARED_POOL_ADVICE)
|
|
| ESTD_LC_SIZE (V$SHARED_POOL_ADVICE)
|
|
| ESTIMATED_ONEPASS_SIZE (V$SQL_PLAN_STATISTICS_ALL)
|
|
| ESTIMATED_ONEPASS_SIZE (GV$SQL_PLAN_STATISTICS_ALL)
|
|
| ESTIMATED_ONEPASS_SIZE (V$SQL_WORKAREA)
|
|
| ESTIMATED_ONEPASS_SIZE (GV$SQL_WORKAREA)
|
|
| ESTIMATED_OPTIMAL_SIZE (V$SQL_WORKAREA)
|
|
| ESTIMATED_OPTIMAL_SIZE (GV$SQL_WORKAREA)
|
|
| ESTIMATED_OPTIMAL_SIZE (V$SQL_PLAN_STATISTICS_ALL)
|
|
| ESTIMATED_OPTIMAL_SIZE (GV$SQL_PLAN_STATISTICS_ALL)
|
|
| EXPECTED_SIZE (V$SQL_WORKAREA_ACTIVE)
|
|
| EXPECTED_SIZE (GV$SQL_WORKAREA_ACTIVE)
|
|
| EXTENT_SIZE (GV$SORT_SEGMENT)
|
|
| EXTENT_SIZE (V$SORT_SEGMENT)
|
|
| EXT_SIZE (V$MAP_FILE_EXTENT)
|
|
| EXT_SIZE (GV$MAP_FILE_EXTENT)
|
|
| FILE_SIZE (V$MAP_FILE)
|
|
| FILE_SIZE (GV$MAP_FILE)
|
|
| FINAL_SIZE (V$SGA_RESIZE_OPS)
|
|
| FINAL_SIZE (GV$SGA_RESIZE_OPS)
|
|
| GRANULE_SIZE (GV$SGA_DYNAMIC_COMPONENTS)
|
|
| GRANULE_SIZE (V$SGA_DYNAMIC_COMPONENTS)
|
|
| HEAP_SIZE (DBA_RGROUP)
| The heap size used for transaction propagation
|
| HEAP_SIZE (ALL_REFRESH_CHILDREN)
| The heap size used for transaction propagation
|
| HEAP_SIZE (ALL_REFRESH)
| The heap size used for transaction propagation
|
| HEAP_SIZE (USER_REFRESH_CHILDREN)
| The heap size used for transaction propagation
|
| HEAP_SIZE (DBA_REFRESH_CHILDREN)
| The heap size used for transaction propagation
|
| HEAP_SIZE (DBA_REFRESH)
| The heap size used for transaction propagation
|
| HEAP_SIZE (USER_REFRESH)
| The heap size used for transaction propagation
|
| HIGH_OPTIMAL_SIZE (V$PGA_TARGET_ADVICE_HISTOGRAM)
|
|
| HIGH_OPTIMAL_SIZE (GV$SQL_WORKAREA_HISTOGRAM)
|
|
| HIGH_OPTIMAL_SIZE (V$SQL_WORKAREA_HISTOGRAM)
|
|
| HIGH_OPTIMAL_SIZE (GV$PGA_TARGET_ADVICE_HISTOGRAM)
|
|
| INITIAL_SIZE (V$SGA_RESIZE_OPS)
|
|
| INITIAL_SIZE (GV$SGA_RESIZE_OPS)
|
|
| INITIAL_SIZE (GV$SGA_CURRENT_RESIZE_OPS)
|
|
| INITIAL_SIZE (V$SGA_CURRENT_RESIZE_OPS)
|
|
| KEY_SIZE (CLU)
| Estimated size of cluster key plus associated rows
|
| KEY_SIZE (DBA_CLUSTERS)
| Estimated size of cluster key plus associated rows
|
| KEY_SIZE (USER_CLUSTERS)
| Estimated size of cluster key plus associated rows
|
| KEY_SIZE (ALL_CLUSTERS)
| Estimated size of cluster key plus associated rows
|
| LAST_ABORTED_SIZE (GV$SHARED_POOL_RESERVED)
|
|
| LAST_ABORTED_SIZE (V$SHARED_POOL_RESERVED)
|
|
| LAST_FAILURE_SIZE (V$SHARED_POOL_RESERVED)
|
|
| LAST_FAILURE_SIZE (GV$SHARED_POOL_RESERVED)
|
|
| LAST_MISS_SIZE (GV$SHARED_POOL_RESERVED)
|
|
| LAST_MISS_SIZE (V$SHARED_POOL_RESERVED)
|
|
| LAST_TEMPSEG_SIZE (GV$SQL_PLAN_STATISTICS_ALL)
|
|
| LAST_TEMPSEG_SIZE (GV$SQL_WORKAREA)
|
|
| LAST_TEMPSEG_SIZE (V$SQL_WORKAREA)
|
|
| LAST_TEMPSEG_SIZE (V$SQL_PLAN_STATISTICS_ALL)
|
|
| LC_FREEABLE_MEMORY_SIZE (V$LIBRARY_CACHE_MEMORY)
|
|
| LC_FREEABLE_MEMORY_SIZE (GV$LIBRARY_CACHE_MEMORY)
|
|
| LC_INUSE_MEMORY_SIZE (V$LIBRARY_CACHE_MEMORY)
|
|
| LC_INUSE_MEMORY_SIZE (GV$LIBRARY_CACHE_MEMORY)
|
|
| LOG_FILE_SIZE_REDO_BLKS (GV$INSTANCE_RECOVERY)
|
|
| LOG_FILE_SIZE_REDO_BLKS (V$INSTANCE_RECOVERY)
|
|
| LOW_OPTIMAL_SIZE (GV$PGA_TARGET_ADVICE_HISTOGRAM)
|
|
| LOW_OPTIMAL_SIZE (GV$SQL_WORKAREA_HISTOGRAM)
|
|
| LOW_OPTIMAL_SIZE (V$SQL_WORKAREA_HISTOGRAM)
|
|
| LOW_OPTIMAL_SIZE (V$PGA_TARGET_ADVICE_HISTOGRAM)
|
|
| MAXIMUM_SIZE (V$SESSION_OBJECT_CACHE)
|
|
| MAXIMUM_SIZE (GV$SESSION_OBJECT_CACHE)
|
|
| MAX_FREE_SIZE (GV$SHARED_POOL_RESERVED)
|
|
| MAX_FREE_SIZE (V$SHARED_POOL_RESERVED)
|
|
| MAX_MISS_SIZE (GV$SHARED_POOL_RESERVED)
|
|
| MAX_MISS_SIZE (V$SHARED_POOL_RESERVED)
|
|
| MAX_SIZE (V$SORT_SEGMENT)
|
|
| MAX_SIZE (GV$SGA_DYNAMIC_COMPONENTS)
|
|
| MAX_SIZE (GV$SORT_SEGMENT)
|
|
| MAX_SIZE (V$SGA_DYNAMIC_COMPONENTS)
|
|
| MAX_SORT_SIZE (V$SORT_SEGMENT)
|
|
| MAX_SORT_SIZE (GV$SORT_SEGMENT)
|
|
| MAX_TEMPSEG_SIZE (V$SQL_WORKAREA)
|
|
| MAX_TEMPSEG_SIZE (GV$SQL_WORKAREA)
|
|
| MAX_TEMPSEG_SIZE (GV$SQL_PLAN_STATISTICS_ALL)
|
|
| MAX_TEMPSEG_SIZE (V$SQL_PLAN_STATISTICS_ALL)
|
|
| MAX_USED_SIZE (V$SHARED_POOL_RESERVED)
|
|
| MAX_USED_SIZE (V$SORT_SEGMENT)
|
|
| MAX_USED_SIZE (GV$SORT_SEGMENT)
|
|
| MAX_USED_SIZE (GV$SHARED_POOL_RESERVED)
|
|
| MEMORY_SIZE (GV$LOGMNR_SESSION)
|
|
| MEMORY_SIZE (V$LOGMNR_SESSION)
|
|
| MIN_SIZE (V$SGA_DYNAMIC_COMPONENTS)
|
|
| MIN_SIZE (GV$SGA_DYNAMIC_COMPONENTS)
|
|
| OPTIMAL_SIZE (GV$SESSION_OBJECT_CACHE)
|
|
| OPTIMAL_SIZE (V$SESSION_OBJECT_CACHE)
|
|
| PARSED_SIZE (DBA_OBJECT_SIZE)
| Size of the parsed form of the object, in bytes. Must be in memory when an object is being compiled that references this object
|
| PARSED_SIZE (USER_OBJECT_SIZE)
| Size of the parsed form of the object, in bytes. Must be in memory when an object is being compiled that references this object
|
| PIPE_SIZE (V$DB_PIPES)
|
|
| PIPE_SIZE (GV$DB_PIPES)
|
|
| POOL_SIZE (V$AW_CALC)
|
|
| POOL_SIZE (GV$AW_CALC)
|
|
| PREV_SIZE (GV$BUFFER_POOL)
|
|
| PREV_SIZE (V$BUFFER_POOL)
|
|
| QUOTA_SIZE (GV$ARCHIVE_DEST)
|
|
| QUOTA_SIZE (V$ARCHIVE_DEST)
|
|
| RECORD_SIZE (V$CONTROLFILE_RECORD_SECTION)
|
|
| RECORD_SIZE (GV$CONTROLFILE_RECORD_SECTION)
|
|
| SAMPLE_SIZE (IND)
| The sample size used in analyzing this index
|
| SAMPLE_SIZE (USER_INDEXES)
| The sample size used in analyzing this index
|
| SAMPLE_SIZE (COLS)
| The sample size used in analyzing this column
|
| SAMPLE_SIZE (ALL_SUBPART_COL_STATISTICS)
|
|
| SAMPLE_SIZE (USER_TAB_PARTITIONS)
|
|
| SAMPLE_SIZE (DBA_OBJECT_TABLES)
| The sample size used in analyzing this table
|
| SAMPLE_SIZE (USER_IND_PARTITIONS)
|
|
| SAMPLE_SIZE (ALL_PART_COL_STATISTICS)
|
|
| SAMPLE_SIZE (USER_TAB_SUBPARTITIONS)
|
|
| SAMPLE_SIZE (ALL_TAB_PARTITIONS)
|
|
| SAMPLE_SIZE (DBA_TAB_COLUMNS)
| The sample size used in analyzing this column
|
| SAMPLE_SIZE (USER_IND_SUBPARTITIONS)
|
|
| SAMPLE_SIZE (ALL_TAB_SUBPARTITIONS)
|
|
| SAMPLE_SIZE (DBA_TABLES)
| The sample size used in analyzing this table
|
| SAMPLE_SIZE (USER_SUBPART_COL_STATISTICS)
|
|
| SAMPLE_SIZE (USER_TAB_COLUMNS)
| The sample size used in analyzing this column
|
| SAMPLE_SIZE (USER_TABLES)
| The sample size used in analyzing this table
|
| SAMPLE_SIZE (TABS)
| The sample size used in analyzing this table
|
| SAMPLE_SIZE (ALL_ALL_TABLES)
| The sample size used in analyzing this table
|
| SAMPLE_SIZE (DBA_IND_SUBPARTITIONS)
|
|
| SAMPLE_SIZE (DBA_ALL_TABLES)
| The sample size used in analyzing this table
|
| SAMPLE_SIZE (USER_TAB_COL_STATISTICS)
| The sample size used in analyzing this column
|
| SAMPLE_SIZE (DBA_SUBPART_COL_STATISTICS)
|
|
| SAMPLE_SIZE (ALL_TAB_COL_STATISTICS)
| The sample size used in analyzing this column
|
| SAMPLE_SIZE (ALL_TAB_COLS)
| The sample size used in analyzing this column
|
| SAMPLE_SIZE (ALL_TAB_COLUMNS)
| The sample size used in analyzing this column
|
| SAMPLE_SIZE (USER_TAB_COLS)
| The sample size used in analyzing this column
|
| SAMPLE_SIZE (DBA_PART_COL_STATISTICS)
|
|
| SAMPLE_SIZE (USER_ALL_TABLES)
| The sample size used in analyzing this table
|
| SAMPLE_SIZE (ALL_IND_PARTITIONS)
|
|
| SAMPLE_SIZE (ALL_TABLES)
| The sample size used in analyzing this table
|
| SAMPLE_SIZE (ALL_IND_SUBPARTITIONS)
|
|
| SAMPLE_SIZE (DBA_TAB_COL_STATISTICS)
| The sample size used in analyzing this column
|
| SAMPLE_SIZE (DBA_INDEXES)
| The sample size used in analyzing this index
|
| SAMPLE_SIZE (DBA_TAB_PARTITIONS)
|
|
| SAMPLE_SIZE (DBA_IND_PARTITIONS)
|
|
| SAMPLE_SIZE (ALL_INDEXES)
| The sample size used in analyzing this index
|
| SAMPLE_SIZE (USER_PART_COL_STATISTICS)
|
|
| SAMPLE_SIZE (DBA_TAB_SUBPARTITIONS)
|
|
| SAMPLE_SIZE (DBA_TAB_COLS)
| The sample size used in analyzing this column
|
| SAMPLE_SIZE (USER_OBJECT_TABLES)
| The sample size used in analyzing this table
|
| SAMPLE_SIZE (ALL_OBJECT_TABLES)
| The sample size used in analyzing this table
|
| SHARED_POOL_SIZE_FACTOR (GV$SHARED_POOL_ADVICE)
|
|
| SHARED_POOL_SIZE_FACTOR (V$SHARED_POOL_ADVICE)
|
|
| SHARED_POOL_SIZE_FOR_ESTIMATE (V$SHARED_POOL_ADVICE)
|
|
| SHARED_POOL_SIZE_FOR_ESTIMATE (GV$SHARED_POOL_ADVICE)
|
|
| SIZE_FACTOR (GV$DB_CACHE_ADVICE)
|
|
| SIZE_FACTOR (V$DB_CACHE_ADVICE)
|
|
| SIZE_FOR_ESTIMATE (GV$DB_CACHE_ADVICE)
|
|
| SIZE_FOR_ESTIMATE (V$DB_CACHE_ADVICE)
|
|
| SOURCE_SIZE (USER_OBJECT_SIZE)
| Size of the source, in bytes. Must be in memory during compilation, or dynamic recompilation
|
| SOURCE_SIZE (DBA_OBJECT_SIZE)
| Size of the source, in bytes. Must be in memory during compilation, or dynamic recompilation
|
| STRIPE_SIZE (GV$MAP_ELEMENT)
|
|
| STRIPE_SIZE (V$MAP_ELEMENT)
|
|
| SUB_SIZE (GV$MAP_SUBELEMENT)
|
|
| SUB_SIZE (V$MAP_SUBELEMENT)
|
|
| TARGET_SIZE (V$SGA_CURRENT_RESIZE_OPS)
|
|
| TARGET_SIZE (V$SGA_RESIZE_OPS)
|
|
| TARGET_SIZE (GV$SGA_CURRENT_RESIZE_OPS)
|
|
| TARGET_SIZE (GV$BUFFER_POOL)
|
|
| TARGET_SIZE (V$BUFFER_POOL)
|
|
| TARGET_SIZE (GV$SGA_RESIZE_OPS)
|
|
| TEMPSEG_SIZE (V$SQL_WORKAREA_ACTIVE)
|
|
| TEMPSEG_SIZE (GV$SQL_WORKAREA_ACTIVE)
|
|
| TYPE_SIZE (GV$TYPE_SIZE)
|
|
| TYPE_SIZE (V$TYPE_SIZE)
|
|
| WORK_AREA_SIZE (GV$SQL_WORKAREA_ACTIVE)
|
|
| WORK_AREA_SIZE (V$SQL_WORKAREA_ACTIVE)
|
|