Ознакомление с распределением пространства базы данных. Управление структурой базы данных, страница 3

SQLWKS> select * from dba_rollback_segs

     2>

SEGMENT_NAME                   OWNER  TABLESPACE_NAME                SEGMENT_ID FILE_ID    BLOCK_ID   INITIAL_EX NEXT_EXTEN MIN_EXTENT MAX_EXTENT PCT_INCREA STATUS           INSTANCE_NUM                           

------------------------------ ------ ------------------------------ ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------------- ----------------------------------------

SYSTEM                         SYS    SYSTEM                                  0          1          2      51200      51200          2        121          0 ONLINE                                                  

RB_TEMP                        SYS    SYSTEM                                  1          1        885      10240      10240          2        121          0 OFFLINE                                                 

RB1                            PUBLIC ROLLBACK_DATA                           2          3          2      51200      51200          2        121          0 ONLINE                                                  

RB2                            PUBLIC ROLLBACK_DATA                           3          3         52      51200      51200          2        121          0 ONLINE                                                  

RB3                            PUBLIC ROLLBACK_DATA                           4          3        102      51200      51200          2        121          0 ONLINE                                                  

RB4                            PUBLIC ROLLBACK_DATA                           5          3        152      51200      51200          2        121          0 ONLINE                                                   

RB5                            PUBLIC ROLLBACK_DATA                           6          3        202      51200      51200          2        121          0 ONLINE                                                  

RB6                            PUBLIC ROLLBACK_DATA                           7          3        252      51200      51200          2        121          0 OFFLINE                                                 

RB7                            PUBLIC ROLLBACK_DATA                           8          3        302      51200      51200          2        121          0 OFFLINE                                                 

RB8                            PUBLIC ROLLBACK_DATA                           9          3        352      51200      51200          2        121          0 OFFLINE                                                 

RB9                            PUBLIC ROLLBACK_DATA                          10          3        402      51200      51200          2        121          0 OFFLINE                                                 

RB10                           PUBLIC ROLLBACK_DATA                          11          3        452      51200      51200          2        121          0 OFFLINE                                                  

RB11                           PUBLIC ROLLBACK_DATA                          12          3        502      51200      51200          2        121          0 OFFLINE                                                 

RB12                           PUBLIC ROLLBACK_DATA                          13          3        552      51200      51200          2        121          0 OFFLINE                                                 

RB13                           PUBLIC ROLLBACK_DATA                          14          3        602      51200      51200          2        121          0 OFFLINE