Rollback segment

[dguywill]

Hi All,
I am having an error with my database and I can't seem to be able to resolve it. The error is as follows:

ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 2 with name "RB1" too small.

This erro occurs when I try to log onto sqlplus..

Thanks in advance,
Dee.

[aracnid]

i don't see a match between entrance in sql and rollback segment
(if you are in audit mode , your db will save same information on system tables, but use system rollback segment) however try to use largeer rollback segs.

[moff]

Increase the size of your rollback segments:

As a guide

'When a mix of transactions is not prevalent, each rollback segment should be 10% of the size of the databases largest table because most SQL affects 10% or less of a table'

Their words not mine!

Hope this helps

Moff