Re: ORA-1555 Snapshots Too Old Error[Q]

In <3qnlqa$odo_at_ixnews4.ix.netcom.com> whitep_at_ix.netcom.com (Perry White) writes:
>
>We are running Oracle 7.0 for a PeopleSoft Payroll system which is
>getting larger and larger. A developer keeps getting the ORA-1555
>snapshot too old error when doing a massive delete or truncate of a
>large work table while payroll is being updated. This error indicates
>the rollback segments are too small. I have added 3 additional
>rollbacks to the database to make a total of 6 with no improvement.
>The settings are "initial 1M minextents 2 next 2M optimal 5M" and are
>the same on all 6 of the segments. How can I tune these rollback
>segments to avoid this error? Are there other measures I can take to
>prevent this error? I think I am ok for day to day updates,its just
>when a massive delete occurs we have this error.
>
>e-mail me directly. Thanks in advance for your suggestions.

Please reply publicly too. I'd like to see the replies.

Thanks.

-- 
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!