Re: Rollback and slow delete

Yes, partitioning your data may help (on a date field and exchanging out older partitions)

but you need to design it properly. Jonathan Lewis' book is good.

So is Oracle Concepts.

Listen to what Sybrand says in another post. He's not making it up. only some things can be done nologging

"TC3 Racer" <gordonchapman_at_hotmailSENDNOSPAM.com> wrote in message news:SDPC9.7391$dz2.953129_at_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 - 12:40:33 CST