Column Name
| Description
|
DROP_SEGMENTS (USER_TAB_MODIFICATIONS)
| Number of (sub)partition segment dropped since the last analyze?
|
DROP_SEGMENTS (ALL_TAB_MODIFICATIONS)
| Number of (sub)partition segment dropped since the last analyze?
|
DROP_SEGMENTS (DBA_TAB_MODIFICATIONS)
| Number of (sub)partition segment dropped since the last analyze?
|
LOB_SEGMENT_NAME (DBA_LOB_TEMPLATES)
|
|
LOB_SEGMENT_NAME (USER_LOB_TEMPLATES)
|
|
LOB_SEGMENT_NAME (ALL_LOB_TEMPLATES)
|
|
MASTER_ROLLBACK_SEG (ALL_SNAPSHOTS)
| Rollback segment to use at the master site
|
MASTER_ROLLBACK_SEG (USER_SNAPSHOTS)
| Rollback segment to use at the master site
|
MASTER_ROLLBACK_SEG (ALL_MVIEWS)
| Name of the rollback segment to use at the master site
|
MASTER_ROLLBACK_SEG (USER_MVIEWS)
| Name of the rollback segment to use at the master site
|
MASTER_ROLLBACK_SEG (DBA_MVIEWS)
| Name of the rollback segment to use at the master site
|
MASTER_ROLLBACK_SEG (DBA_SNAPSHOTS)
| Rollback segment to use at the master site
|
MASTER_ROLLBACK_SEGMENT (ALL_REPCAT_TEMPLATE_OBJECTS)
| Rollback segment for use during snapshot refreshes.
|
MASTER_ROLLBACK_SEGMENT (DBA_REPCAT_TEMPLATE_OBJECTS)
| Rollback segment for use during snapshot refreshes.
|
MASTER_ROLLBACK_SEGMENT (USER_REPCAT_TEMPLATE_OBJECTS)
| Rollback segment for use during snapshot refreshes.
|
ROLLBACK_SEG (DBA_REFRESH)
| Name of the rollback segment to use while refreshing
|
ROLLBACK_SEG (USER_REFRESH_CHILDREN)
| Name of the rollback segment to use while refreshing
|
ROLLBACK_SEG (USER_REFRESH)
| Name of the rollback segment to use while refreshing
|
ROLLBACK_SEG (DBA_REFRESH_CHILDREN)
| Name of the rollback segment to use while refreshing
|
ROLLBACK_SEG (ALL_REFRESH_CHILDREN)
| Name of the rollback segment to use while refreshing
|
ROLLBACK_SEG (DBA_RGROUP)
| Name of the rollback segment to use while refreshing
|
ROLLBACK_SEG (DBA_TEMPLATE_REFGROUPS)
| Name of the rollback segment to use during refresh.
|
ROLLBACK_SEG (ALL_REFRESH)
| Name of the rollback segment to use while refreshing
|
SEGBLK# (V$TEMPSEG_USAGE)
|
|
SEGBLK# (GV$TEMPSEG_USAGE)
|
|
SEGBLK# (V$SORT_USAGE)
|
|
SEGBLK# (GV$SQL_WORKAREA_ACTIVE)
|
|
SEGBLK# (V$SQL_WORKAREA_ACTIVE)
|
|
SEGBLK# (GV$SORT_USAGE)
|
|
SEGFILE# (V$SORT_USAGE)
|
|
SEGFILE# (GV$SORT_USAGE)
|
|
SEGFILE# (V$TEMPSEG_USAGE)
|
|
SEGFILE# (GV$TEMPSEG_USAGE)
|
|
SEGMENT_BLOCK (DBA_DMT_USED_EXTENTS)
| Block number of segment header of the extent
|
SEGMENT_BLOCK (DBA_LMT_USED_EXTENTS)
| Block number of segment header of the extent
|
SEGMENT_BLOCK (V$SORT_SEGMENT)
|
|
SEGMENT_BLOCK (GV$SORT_SEGMENT)
|
|
SEGMENT_COLUMN_ID (USER_TAB_COLS)
| Sequence number of the column in the segment
|
SEGMENT_COLUMN_ID (DBA_TAB_COLS)
| Sequence number of the column in the segment
|
SEGMENT_COLUMN_ID (ALL_TAB_COLS)
| Sequence number of the column in the segment
|
SEGMENT_FILE (GV$SORT_SEGMENT)
|
|
SEGMENT_FILE (V$SORT_SEGMENT)
|
|
SEGMENT_FILEID (DBA_LMT_USED_EXTENTS)
| File number of segment header of the extent
|
SEGMENT_FILEID (DBA_DMT_USED_EXTENTS)
| File number of segment header of the extent
|
SEGMENT_ID (DBA_ROLLBACK_SEGS)
| ID number of the rollback segment
|
SEGMENT_NAME (DBA_LOBS)
| Name of the LOB segment
|
SEGMENT_NAME (USER_LOBS)
| Name of the LOB segment
|
SEGMENT_NAME (USER_EXTENTS)
| Name of the segment associated with the extent
|
SEGMENT_NAME (DBA_ROLLBACK_SEGS)
| Name of the rollback segment
|
SEGMENT_NAME (USER_SEGMENTS)
| Name, if any, of the segment
|
SEGMENT_NAME (ALL_LOBS)
| Name of the LOB segment
|
SEGMENT_NAME (DBA_SEGMENTS)
| Name, if any, of the segment
|
SEGMENT_NAME (DBA_EXTENTS)
| Name of the segment associated with the extent
|
SEGMENT_NAME (DBA_UNDO_EXTENTS)
| Name of the segment associated with the extent
|
SEGMENT_SPACE_MANAGEMENT (DBA_TABLESPACES)
| Segment space management tracking: "AUTO" or "MANUAL"
|
SEGMENT_SPACE_MANAGEMENT (USER_TABLESPACES)
| Segment space management tracking: "AUTO" or "MANUAL"
|
SEGMENT_TYPE (USER_SEGMENTS)
| Type of segment: "TABLE", "CLUSTER", "INDEX", "ROLLBACK", "DEFERRED ROLLBACK", "TEMPORARY", "SPACE HEADER", "TYPE2 UNDO" or "CACHE"
|
SEGMENT_TYPE (DBA_EXTENTS)
| Type of the segment
|
SEGMENT_TYPE (USER_EXTENTS)
| Type of the segment
|
SEGMENT_TYPE (DBA_SEGMENTS)
| Type of segment: "TABLE", "CLUSTER", "INDEX", "ROLLBACK", "DEFERRED ROLLBACK", "TEMPORARY","SPACE HEADER", "TYPE2 UNDO" or "CACHE"
|
SEGRFNO# (V$TEMPSEG_USAGE)
|
|
SEGRFNO# (V$SORT_USAGE)
|
|
SEGRFNO# (GV$SQL_WORKAREA_ACTIVE)
|
|
SEGRFNO# (GV$SORT_USAGE)
|
|
SEGRFNO# (GV$TEMPSEG_USAGE)
|
|
SEGRFNO# (V$SQL_WORKAREA_ACTIVE)
|
|
SEGTYPE (GV$TEMPSEG_USAGE)
|
|
SEGTYPE (GV$SORT_USAGE)
|
|
SEGTYPE (V$SORT_USAGE)
|
|
SEGTYPE (V$TEMPSEG_USAGE)
|
|
SEG_NAME (V$LOGMNR_CONTENTS)
|
|
SEG_NAME (GV$LOGMNR_CONTENTS)
|
|
SEG_OWNER (V$LOGMNR_CONTENTS)
|
|
SEG_OWNER (GV$LOGMNR_CONTENTS)
|
|
SEG_TYPE (GV$LOGMNR_CONTENTS)
|
|
SEG_TYPE (V$LOGMNR_CONTENTS)
|
|
SEG_TYPE_NAME (V$LOGMNR_CONTENTS)
|
|
SEG_TYPE_NAME (GV$LOGMNR_CONTENTS)
|
|