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

In article <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.

Since Oracle transactions cannot utilize more than one RBS, it's not the number of RBS that solves the problem; it's the size of RBS.

Try pump up the nextextent and/or optimal parameters of the RBS.

--
"And this is all I have to say about that..."   - F. Gump
      ___
     (o o)
+-oo0-\_/-0oo---------------------------------------------------------------+
|  Alvin W. Law ..... Oracle Corporation ....... Email: alaw_at_us.oracle.com  |
+---------------------------------------------------------------------------+

ORA-03113: end-of-file on communication channel