| Column Name
| Description
|
| ACTUAL_MEM_USED (GV$SQL_WORKAREA_ACTIVE)
|
|
| ACTUAL_MEM_USED (V$SQL_WORKAREA_ACTIVE)
|
|
| AVG_USED_SIZE (GV$SHARED_POOL_RESERVED)
|
|
| AVG_USED_SIZE (V$SHARED_POOL_RESERVED)
|
|
| BLOCKS_USED (GV$TEMP_SPACE_HEADER)
|
|
| BLOCKS_USED (V$TEMP_SPACE_HEADER)
|
|
| BLOCKS_USED (V$TEMP_EXTENT_POOL)
|
|
| BLOCKS_USED (GV$TEMP_EXTENT_POOL)
|
|
| BYTES_USED (V$TEMP_EXTENT_POOL)
|
|
| BYTES_USED (V$TEMP_SPACE_HEADER)
|
|
| BYTES_USED (GV$TEMP_SPACE_HEADER)
|
|
| BYTES_USED (GV$TEMP_EXTENT_POOL)
|
|
| CAN_USE_LOG (ALL_REGISTERED_MVIEWS)
| If NO, this materialized view is complex and cannot fast refresh
|
| CAN_USE_LOG (DBA_SNAPSHOTS)
| If NO, this snapshot is complex and will never use a log
|
| CAN_USE_LOG (DBA_REGISTERED_SNAPSHOTS)
| If NO, this snapshot is complex and cannot fast refresh
|
| CAN_USE_LOG (ALL_REGISTERED_SNAPSHOTS)
| If NO, this snapshot is complex and cannot fast refresh
|
| CAN_USE_LOG (USER_REGISTERED_SNAPSHOTS)
| If NO, this snapshot is complex and cannot fast refresh
|
| CAN_USE_LOG (USER_SNAPSHOTS)
| If NO, this snapshot is complex and will never use a log
|
| CAN_USE_LOG (USER_REGISTERED_MVIEWS)
| If NO, this materialized view is complex and cannot fast refresh
|
| CAN_USE_LOG (DBA_REGISTERED_MVIEWS)
| If NO, this materialized view is complex and cannot fast refresh
|
| CAN_USE_LOG (ALL_SNAPSHOTS)
| If NO, this snapshot is complex and will never use a log
|
| CHAR_USED (USER_REPCOLUMN)
| C if the width was specified in characters, B if in bytes
|
| CHAR_USED (DBA_TAB_COLS)
| C if the width was specified in characters, B if in bytes
|
| CHAR_USED (USER_ARGUMENTS)
| Is the byte limit (B) or char limit (C) official for this string?
|
| CHAR_USED (ALL_REPCOLUMN)
| C if the width was specified in characters, B if in bytes
|
| CHAR_USED (ALL_TAB_COLS)
| C if maximum length is specified in characters, B if in bytes
|
| CHAR_USED (USER_TAB_COLUMNS)
| C is maximum length given in characters, B if in bytes
|
| CHAR_USED (DBA_REPCOLUMN)
| C if the width was specified in characters, B if in bytes
|
| CHAR_USED (COLS)
| C is maximum length given in characters, B if in bytes
|
| CHAR_USED (DBA_TAB_COLUMNS)
| C if the width was specified in characters, B if in bytes
|
| CHAR_USED (ALL_TAB_COLUMNS)
| C if maximum length is specified in characters, B if in bytes
|
| CHAR_USED (ALL_ARGUMENTS)
| Is the byte limit (B) or char limit (C) official for this string?
|
| CHAR_USED (USER_TAB_COLS)
| C is maximum length given in characters, B if in bytes
|
| DEF_PCT_USED (USER_PART_TABLES)
|
|
| DEF_PCT_USED (ALL_PART_TABLES)
|
|
| DEF_PCT_USED (DBA_PART_TABLES)
|
|
| EXTENTS_USED (GV$TEMP_EXTENT_POOL)
|
|
| EXTENTS_USED (V$TEMP_EXTENT_POOL)
|
|
| HEAP_USED (V$SUBCACHE)
|
|
| HEAP_USED (GV$SUBCACHE)
|
|
| LAST_MEMORY_USED (GV$SQL_PLAN_STATISTICS_ALL)
|
|
| LAST_MEMORY_USED (V$SQL_WORKAREA)
|
|
| LAST_MEMORY_USED (V$SQL_PLAN_STATISTICS_ALL)
|
|
| LAST_MEMORY_USED (GV$SQL_WORKAREA)
|
|
| MAX_MEM_USED (GV$SQL_WORKAREA_ACTIVE)
|
|
| MAX_MEM_USED (V$SQL_WORKAREA_ACTIVE)
|
|
| MAX_USED_BLOCKS (GV$SORT_SEGMENT)
|
|
| MAX_USED_BLOCKS (V$SORT_SEGMENT)
|
|
| MAX_USED_SIZE (V$SHARED_POOL_RESERVED)
|
|
| MAX_USED_SIZE (V$SORT_SEGMENT)
|
|
| MAX_USED_SIZE (GV$SHARED_POOL_RESERVED)
|
|
| MAX_USED_SIZE (GV$SORT_SEGMENT)
|
|
| PCT_USED (CLU)
| Minimum percentage of used space in a block
|
| PCT_USED (USER_OBJECT_TABLES)
| Minimum percentage of used space in a block
|
| PCT_USED (DBA_TAB_SUBPARTITIONS)
|
|
| PCT_USED (ALL_CLUSTERS)
| Minimum percentage of used space in a block
|
| PCT_USED (USER_TAB_SUBPARTITIONS)
|
|
| PCT_USED (DBA_CLUSTERS)
| Minimum percentage of used space in a block
|
| PCT_USED (ALL_TABLES)
| Minimum percentage of used space in a block
|
| PCT_USED (ALL_TAB_SUBPARTITIONS)
|
|
| PCT_USED (DBA_TABLES)
| Minimum percentage of used space in a block
|
| PCT_USED (USER_ALL_TABLES)
| Minimum percentage of used space in a block
|
| PCT_USED (DBA_ALL_TABLES)
| Minimum percentage of used space in a block
|
| PCT_USED (DBA_TAB_PARTITIONS)
|
|
| PCT_USED (ALL_TAB_PARTITIONS)
|
|
| PCT_USED (DBA_OBJECT_TABLES)
| Minimum percentage of used space in a block
|
| PCT_USED (USER_TAB_PARTITIONS)
|
|
| PCT_USED (USER_CLUSTERS)
| Minimum percentage of used space in a block
|
| PCT_USED (TABS)
| Minimum percentage of used space in a block
|
| PCT_USED (USER_TABLES)
| Minimum percentage of used space in a block
|
| PCT_USED (ALL_ALL_TABLES)
| Minimum percentage of used space in a block
|
| PCT_USED (ALL_OBJECT_TABLES)
| Minimum percentage of used space in a block
|
| PGA_USED_MEM (GV$PROCESS)
|
|
| PGA_USED_MEM (V$PROCESS)
|
|
| PRIV_USED (DBA_AUDIT_STATEMENT)
|
|
| PRIV_USED (DBA_AUDIT_OBJECT)
|
|
| PRIV_USED (USER_AUDIT_OBJECT)
|
|
| PRIV_USED (DBA_AUDIT_TRAIL)
| System privilege used to execute the action
|
| PRIV_USED (USER_AUDIT_STATEMENT)
|
|
| PRIV_USED (USER_AUDIT_TRAIL)
| System privilege used to execute the action
|
| QUOTA_USED (V$ARCHIVE_DEST)
|
|
| QUOTA_USED (GV$ARCHIVE_DEST)
|
|
| RECORDS_USED (GV$CONTROLFILE_RECORD_SECTION)
|
|
| RECORDS_USED (V$CONTROLFILE_RECORD_SECTION)
|
|
| SGA_USED (GV$STREAMS_APPLY_READER)
|
|
| SGA_USED (V$STREAMS_APPLY_READER)
|
|
| USED (V$STANDBY_LOG)
|
|
| USED (USER_OUTLINES)
| Flag indicating whether the outline has ever been used
|
| USED (ALL_OUTLINES)
| Flag indicating whether the outline has ever been used
|
| USED (DBA_OUTLINES)
| Flag indicating whether the outline has ever been used
|
| USED (GV$STANDBY_LOG)
|
|
| USED_BLOCKS (V$SORT_SEGMENT)
|
|
| USED_BLOCKS (GV$SORT_SEGMENT)
|
|
| USED_COUNT (GV$SHARED_POOL_RESERVED)
|
|
| USED_COUNT (V$SHARED_POOL_RESERVED)
|
|
| USED_EXTENTS (V$SORT_SEGMENT)
|
|
| USED_EXTENTS (GV$SORT_SEGMENT)
|
|
| USED_SPACE (V$SHARED_POOL_RESERVED)
|
|
| USED_SPACE (GV$SHARED_POOL_RESERVED)
|
|
| USED_UBLK (V$TRANSACTION)
|
|
| USED_UBLK (GV$TRANSACTION)
|
|
| USED_UREC (GV$TRANSACTION)
|
|
| USED_UREC (V$TRANSACTION)
|
|
| USE_COUNT (GV$BACKUP_ASYNC_IO)
|
|
| USE_COUNT (GV$BACKUP_SYNC_IO)
|
|
| USE_COUNT (V$BACKUP_ASYNC_IO)
|
|
| USE_COUNT (V$BACKUP_SYNC_IO)
|
|
| USE_NO_INDEX (ALL_MVIEWS)
| Indicates whether the MV uses no index
|
| USE_NO_INDEX (USER_MVIEWS)
| Indicates whether the MV uses no index
|
| USE_NO_INDEX (DBA_MVIEWS)
| Indicates whether the MV uses no index
|