Suggestions please on my RBS parameters
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Suggestions please on my RBS parameters

  1. #1
    Join Date
    Oct 2000
    Posts
    76
    I have a db as backend for an i2 application. They are batch loading data to the database, and we repeatedly ran out of extents in the rollback segments.

    I have 4 RBS. This is my current settings:

    SQL> select usn,extents,optsize,hwmsize,wraps,extends from v$rollstat;

    USN EXTENTS OPTSIZE HWMSIZE WRAPS EXTENDS
    ---------- ---------- ---------- ---------- ---------- ----------
    2 21 10485760 10747904 0 0
    3 21 10485760 10747904 0 0
    4 21 10485760 10747904 0 0
    5 21 10485760 10747904 0 0

    SEGMENT_NAME INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS
    ------------------------------ -------------- ----------- ----------- -----------
    SYSTEM 53248 53248 2 249
    R000 512000 512000 2 249
    R01 512000 512000 5 505
    R02 512000 512000 5 505
    R03 512000 512000 5 505
    R04 512000 512000 5 505

    So my question is that if I have total of 505 maxextents, and in v$rollstat extent column I have only upto 21, and no wraps and no extends, how come I am getting errors like:

    Failure to extend rollback segment 3
    Failure to extend rollback segment 3 because of 1562 condition

    How should I modify my parameters to fix this?

    J.T.

  2. #2
    Join Date
    Nov 2000
    Posts
    224
    Can you change the batch loading process, If Yes, What about creating new RBS or changing the parameter of existing segment to High value of INITIAL & NEXT. Assign this RBS to Batch loading transaction, before it starts using Set transaction ............

  3. #3
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    How much free space is left in the Rollbacks tablespace?
    There should also be another error message after the 1562, particularly in the alert log.

    You may be running out of tablespace room, not extents. But the next error message will point you closer to the problem.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

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