Re: Deleting Large Numbers of Rows w/o Filling up my redo logs

From: Mladen Gogala <>
Date: Mon, 22 Dec 2008 10:51:23 +0000 (UTC)
Message-ID: <ginrfa$ll0$>

On Sun, 21 Dec 2008 10:35:53 -0800, Mark D Powell wrote:

> But if you delete a million rows in one transaction or 10 should not
> make much of a difference to the total amount of redo log generated.
> Commiting after every row on the other hand should actually increase the
> redo being generated since you would have to also log all the commits.
> The more I think about the issue I think you might want to take a
> careful look at your undo statistics during this job.
> HTH -- Mark D Powell --

In some Oracle versions after 8.1.7 there is an option called "total recall" which allows you to specify record retention time. Everything older then that will drift in the "archive" which is a structure created in a normal tablespace and tied to the table in question. That may be the answer to mass deletion and archiving the table contents. Those same versions will allow you to compress OLTP tables by specifying "COMPRESS FOR ALL OPERATIONS" so that you can save space very efficiently.

Mladen Gogala
Received on Mon Dec 22 2008 - 04:51:23 CST

Original text of this message