Re: Help: Rollbacks Keep Blowing Up-v7.1.4
From: LGAARD <lgaard_at_aol.com>
Date: 7 Feb 1995 03:23:40 -0500
Message-ID: <3h7amc$s7q_at_newsbf02.news.aol.com>
Date: 7 Feb 1995 03:23:40 -0500
Message-ID: <3h7amc$s7q_at_newsbf02.news.aol.com>
On 2 Feb 1995, Bill Hungerford wrote:
> Multiple SQL scripts running on system are blowing up due to rollback
> segments ("snapshot too old").
>
> Also, it appears that when these jobs run, the rollback segments aren't
> going into extents.
>
- If you have optimal set to a number less than 10 extents or so, increase it to size of 20 extents. This way the extents that the select is looking at are less likely to have been written over or shrunk.
- You may want to just increase the number of rollback segments. That way you will also reduce the probability that one transaction will get around to using the rollback extents that the long query was still trying to get through.
To review: more extents at optimal (not to more than 30 probably) and/or
more rollback segments.
I hope that helps.
Laurel
Received on Tue Feb 07 1995 - 09:23:40 CET