Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Select from DBA_SEGMENTS where Segment_Type = ROLLBACK

SQL> SQL> select * from DBA_SEGMENTS   2   where Segment_Type = 'ROLLBACK';                                                                OWNER         SEGMENT_NAME ------------  --------------------------------------------------------------------------------- PARTITION_NAME                  SEGMENT_TYPE        TABLESPACE_NAME                 HEADER_FILE  HEADER_BLOCK ------------------------------  ------------------  ------------------------------  -----------  ------------      BYTES      BLOCKS     EXTENTS  INITIAL_EXTENT  NEXT_EXTENT  MIN_EXTENTS  MAX_EXTENTS  PCT_INCREASE   FREELISTS ----------  ----------  ----------  --------------  -----------  -----------  -----------  ------------  ---------- FREELIST_GROUPS  RELATIVE_FNO  BUFFER_ ---------------  ------------  ------- SYS           SYSTEM                                 ROLLBACK            SYSTEM                                    1             9     393216          48           6          114688      1048576            1        32765             0           1               1             1  DEFAULT                    SQL>