Re: most expeditious way to update a large number of rows

From: <mylesv_at_gmail.com>
Date: 16 Oct 2006 13:25:11 -0700
Message-ID: <1161030311.212982.311060@h48g2000cwc.googlegroups.com>

DA Morgan wrote:
> I think your question indicates you came to Oracle from a database of
> the Ingres family (SQL Server, Sybase, or Informix). The size of your
> redo logs is likely too small but that is irrelevant to the question
> you asked as Oracle's log files do not work as you expect. I can
> easily run a 1TB transaction, in Oracle, with a couple of 1MB log files.
>
> Fix your code ... but not before you hit the Concept books at
> http://tahiti.oracle.com and visit amazon and pick up every one of Tom
> Kyte's books.

Ok, help me understand. Approximately how much "redo" will my update generate? I'm modifiying a single varchar(19) field in every row (671,000 rows). Block size is 8kB.

Thanks,
Myles Received on Mon Oct 16 2006 - 15:25:11 CDT