DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 20

Thread: Rollback segments: maxextents changed during create?

Threaded View

  1. #9
    Join Date
    Oct 2002
    Location
    Breda, The Netherlands
    Posts
    317
    And again... same result

    Code:
    CREATE PUBLIC ROLLBACK SEGMENT RBS04     
        TABLESPACE RBS3     
        STORAGE ( INITIAL 512 NEXT 512K MINEXTENTS 10 MAXEXTENTS 400)
    
    
    rollback-segment created.
    
    SQL> select segment_name,MIN_EXTENTS,MAX_EXTENTS  
           from sys.dba_rollback_segs;
    
    SEGMENT_NAME                   MIN_EXTENTS MAX_EXTENTS
    ------------------------------ ----------- -----------
    SYSTEM                                   2         505
    RBS0                                     8        8192
    RBS1                                     8        8192
    
    ... etc etc...
    
    RBS8                                     8        8192
    RBS9                                     8        8192
    
    SEGMENT_NAME                   MIN_EXTENTS MAX_EXTENTS
    ------------------------------ ----------- -----------
    RBS03                                    1       32765
    RBS02                                    1       32765
    RBS04                                    1       32765
    I'm confused...
    Last edited by efrijters; 12-04-2003 at 08:26 AM.
    An expert is one who knows more and more about less and less until he knows absolutely everything about nothing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width