home - keyword index

Keyword: SEGMENT

jump to Columns back to index

Tables

Table Name Description
DBA_SEGMENTS Storage allocated for all database segments
GV$SEGMENT_STATISTICS Synonym for GV_$SEGMENT_STATISTICS
GV$SEGSTAT Synonym for GV_$SEGSTAT
GV$SEGSTAT_NAME Synonym for GV_$SEGSTAT_NAME
GV$SORT_SEGMENT Synonym for GV_$SORT_SEGMENT
USER_SEGMENTS Storage allocated for all database segments
V$SEGMENT_STATISTICS Synonym for V_$SEGMENT_STATISTICS
V$SEGSTAT Synonym for V_$SEGSTAT
V$SEGSTAT_NAME Synonym for V_$SEGSTAT_NAME
V$SORT_SEGMENT Synonym for V_$SORT_SEGMENT
top back to index

Columns

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)
top back to index

Comment on this page:




home - keyword index