5.292 DBA_ROLLBACK_SEGS
DBA_ROLLBACK_SEGS
describes rollback segments.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Name of the rollback segment |
|
|
|
Owner of the rollback segment:
|
|
|
|
Name of the tablespace containing the rollback segment |
|
|
|
ID number of the rollback segment |
|
|
|
File identifier number of the file containing the segment head |
|
|
|
ID number of the block containing the segment header |
|
|
|
Initial extent size in bytes |
|
|
|
Secondary extent size in bytes |
|
|
|
Minimum number of extents |
|
|
|
Maximum number of extent |
|
|
|
Percent increase for extent size |
|
|
|
Rollback segment status:
|
|
|
|
Rollback segment owning Oracle Real Application Clusters instance number |
|
|
|
Relative file number of the segment header |