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

Thread: minimum number of extents in RBS

  1. #1
    Join Date
    Apr 2001
    Posts
    257
    Hi,

    What is the minimum number of extents in a rollback segment? Some people say one while others say two. I looked up the Oracle docs and it says one.

    Does anyone know the answer for sure?

    Thanks.

  2. #2
    Join Date
    Feb 2002
    Location
    http://db-migration.co.in
    Posts
    50
    Hi,

    The minextents parameter for rollback segemnts has to be >= 2. If u supply 1 as minextents parameter, u will get error as follows :
    SQL> create rollback segment abc storage (minextents 1);
    create rollback segment abc storage (minextents 1)
    *
    ERROR at line 1:
    ORA-01556: MINEXTENTS for rollback segment must be greater than 1

    Prakash

  3. #3
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Whoever told you "ONE" should have their butt kicked. What's even more concerning is that you said "some people...". It's a worry...I hope they weren't your fellow DBA's!

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia

  4. #4
    Join Date
    Feb 2002
    Location
    Dallas , Texas
    Posts
    158
    Hi,
    The minimum extent should be more than or equal to 2 but the recomended is 20.
    Take Care,
    Nishant.

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