Skip to content

DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_ROLLBACK_SEGS

Object Details
Object Name: DBA_ROLLBACK_SEGS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of rollback segments

[View Source]

Columns
Name Datatype Length Mandatory Comments
SEGMENT_NAME VARCHAR2 (30) Yes Name of the rollback segment
OWNER VARCHAR2 (6)
Owner of the rollback segment
TABLESPACE_NAME VARCHAR2 (30) Yes Name of the tablespace containing the rollback segment
SEGMENT_ID NUMBER
Yes ID number of the rollback segment
FILE_ID NUMBER
Yes ID number of the file containing the segment header
BLOCK_ID NUMBER
Yes ID number of the block containing the segment header
INITIAL_EXTENT NUMBER

Initial extent size in bytes
NEXT_EXTENT NUMBER

Secondary extent size in bytes
MIN_EXTENTS NUMBER
Yes Minimum number of extents
MAX_EXTENTS NUMBER
Yes Maximum number of extents
PCT_INCREASE NUMBER

Percent increase for extent size
STATUS VARCHAR2 (16)
Rollback segment status
INSTANCE_NUM VARCHAR2 (40)
Rollback segment owning parallel server instance number
RELATIVE_FNO NUMBER
Yes Relative number of the file containing the segment header
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SEGMENT_NAME
,      OWNER
,      TABLESPACE_NAME
,      SEGMENT_ID
,      FILE_ID
,      BLOCK_ID
,      INITIAL_EXTENT
,      NEXT_EXTENT
,      MIN_EXTENTS
,      MAX_EXTENTS
,      PCT_INCREASE
,      STATUS
,      INSTANCE_NUM
,      RELATIVE_FNO
FROM SYS.DBA_ROLLBACK_SEGS;

Dependencies

[top of page]

SYS.DBA_ROLLBACK_SEGS references the following:

SchemaSYS
TableFILE$
TableSEG$
TableTS$
TableUNDO$
SYS.DBA_ROLLBACK_SEGS is referenced by following:

SchemaPUBLIC
SynonymDBA_ROLLBACK_SEGS
SchemaSYS
Package BodyDBMS_SNAPSHOT_UTL - show dependent code
Package BodyINITJVMAUX - show dependent code