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
|