DBA Data[Home] [Help]

VIEW: SYS.CDB_ROLLBACK_SEGS

Source

View Text - Preformatted

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","CON_ID" FROM CONTAINERS("SYS"."DBA_ROLLBACK_SEGS")
View Text - HTML Formatted

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"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_ROLLBACK_SEGS")