>HI Tim,
>Thank you for the tips. One question. If the RBS were increased enough to allow me to delete all rows in a single command, would this improve the time it takes to delete all rows ?
>
>Thank you for your help,
>Christian
It is common to have a HUGE RBS and assign
a specific transaction to this rollback segement..This way only one
RBS is used thus helping with some processing.
I think it looks like:
SET TRANSACTION USE ROLLBACK SEGMENT large_rs1;
DELETE blah blah;
If the RBS is too small you will likely get rollback errors during thye execution of the command.
HTH
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement