Table: DBA_ROLLBACK_SEGS
Description of rollback segments
| Column Name | Description |
|---|---|
| BLOCK_ID | ID number of the block containing the segment header |
| FILE_ID | ID number of the file containing the segment header |
| INITIAL_EXTENT | Initial extent size in bytes |
| INSTANCE_NUM | Rollback segment owning parallel server instance number |
| MAX_EXTENTS | Maximum number of extents |
| MIN_EXTENTS | Minimum number of extents |
| NEXT_EXTENT | Secondary extent size in bytes |
| OWNER | Owner of the rollback segment |
| PCT_INCREASE | Percent increase for extent size |
| RELATIVE_FNO | Relative number of the file containing the segment header |
| SEGMENT_ID | ID number of the rollback segment |
| SEGMENT_NAME | Name of the rollback segment |
| STATUS | Rollback segment status |
| TABLESPACE_NAME | Name of the tablespace containing the rollback segment |