Rollback and slow delete

From: TC3 Racer <gordonchapman_at_hotmailSENDNOSPAM.com>
Date: Wed, 20 Nov 2002 17:29:15 -0000
Message-ID: <SDPC9.7391$dz2.953129@stones>

Using Oracle 8i/NT4, the amount of data being loaded as suddenly increased and we have started getting performance problems when deleting

In 5 days we have 14,000,000 rows and we delete ( or try to delete) any data old than 2.5 days, but are getting the error

'ORA-01555: snapshot too old: rollback segment number 5 with name "RBS4" too small'

I'm not bothered about recovering this so I've set 'nologging' but it still writes to the redo log.

Will partitioning the table also help

Thanks

GC Received on Wed Nov 20 2002 - 11:29:15 CST