Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    3

    Unanswered: rollback segment waits

    Hi,
    If I do select * from v$waitstat I find a lot of waits for :

    undo header 933 87
    undo block 3427 150

    Does this mean I have to increase the number of rollback segments? Or increase the size. Does anyone have experience with it? Thank you.

  2. #2
    Join Date
    Oct 2003
    Posts
    5
    Hi,
    Increase the no of rollback segments. It will help you.

Posting Permissions

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