ORA-1555 Snapshots Too Old Error[Q]
Date: 1995/06/02
Message-ID: <3qnlqa$odo_at_ixnews4.ix.netcom.com>#1/1
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.
-- __________________________________________________ Perry White, DBA whitep_at_ix.netcom.com Koch Industries, Inc. CIS: 72702,1631 Wichita, KS 67220 Office: (316)832-8411 ** All opinions expressed are strictly my own **Received on Fri Jun 02 1995 - 00:00:00 CEST