Rollback segment error not Production system but not on test
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Rollback segment error not Production system but not on test

  1. #1
    Join Date
    Apr 2001
    Posts
    112

    Rollback segment error not Production system but not on test

    Hi
    I have 2 instances on 2 separate servers , they are configured the same in all aspects.
    Now on the production instance Im running into rollback cannot extend errors but the same process is running just fine. The workload on both the machines is same.
    Can anyone help me in solving this mystery.

    thx

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Something is not the same. Check rollback segments, autoextend on your datafiles, optimal settings, etc.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Please post exact error messages.
    What sizes are you rollback segments? How many of them?
    How many users on each system?

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