DBA_ROLLBACK_SEGS

SQL>DESC DBA_ROLLBACK_SEGS

 Name                                              Null?                    Type
 ----------------------------------------- -------- ---------   -----------------
 SEGMENT_NAME                      NOT NULL        VARCHAR2(30)
 OWNER                                                                      VARCHAR2(6)
 TABLESPACE_NAME               NOT NULL            VARCHAR2(30)
 SEGMENT_ID                             NOT NULL             NUMBER
 FILE_ID                                       NOT NULL               NUMBER
 BLOCK_ID                                  NOT NULL              NUMBER
 INITIAL_EXTENT                                                      NUMBER
 NEXT_EXTENT                                                          NUMBER
 MIN_EXTENTS                          NOT NULL            NUMBER
 MAX_EXTENTS                        NOT NULL           NUMBER
 PCT_INCREASE                                                      NUMBER
 STATUS                                                                     VARCHAR2(16)
 INSTANCE_NUM                                                    VARCHAR2(40)
 RELATIVE_FNO                    NOT NULL               NUMBER

No comments:

Post a Comment