Re: ORA - 01555 rollback segment too old

Maria wrote:

> Hi all
>
> I have a database which is about 500GB in size, a tablespace for the
> ROLLBACK which is 40GG with 20 rollback @ 780MB each, then we
> introduce partition tables after about 2 weeks we start getting
> "ORA-01555 rollback segment RBS1 too old, too small" I called oracle
> support on this they are useless, they are just giving me notes to
> read, which most of them do not apply (I have a data warehouse db). I
> don't know what to do anymore? currently we are planning to hard code
> a rollback to this job which fails, which drop and recreates a
> partition table with 2 partitions, is there any issues with rollback
> segments with partition tables? should I increase the rollback's from
> 20 to 30 rollback segments? any ideas would be great, I'm running out
> of ideas as what to do next
> Thanks
> Maria

A few brief comments and questions:

1. A version number would be helpful don't you think?
2. If you have introduced incremental commits remove them.
3. The sizes of your rollback segments are not as you say. 780MB initial extent? next extent? Or at max extents?
4. What is the number of simultaneous transactions and the number of users/transaction in your init.ora?
5. What is the size of your largest table?

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)