Re: Snapshot too old: Rollback Segment number xx with name 'ccc' too small

Are you sure that you're using the right rollback segment? Issue the command
set transaction use rollback segment <big rollback segment name> before your update

and from a different connection use

select * from v$rollstats where usn = <int>

where <int> is the id for the rollback segment you're using (you can find the usn by looking in v$rollname)

Keep re-issueing the select until you find out what the problem is or the update works.

Raymond Field

D Huynh wrote:

> I have a test application that opens a table, goes thru a loop and
> inidividually updates each of the 2 millions records. About 500,000 records
> into the run, the above error (Rollback segment too small) occurs and the
> apps terminates.
>
> I've expanded the rollback segment table space, expanded each individual
> rollback segment with a unlimited number of extends (each extends is set to
> 125 data blocks).
>
> I shut down and restart the instance, and event try to reboot the manchine,
> but the rollback segments seem to stay at .293 Mb (300kb). And the program
> still faileds.
>
> I know that a real app is not supposed to perform that many trans with
> explicitly committing them, but how can I make the rollback segment bigger
> so that my test app won't fail.
>
> TIA.
Received on Wed Jan 13 1999 - 11:29:47 CST