mylesv_at_gmail.com wrote:
> 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
Unless my guess about your background is incorrect, you didn't respond
to that part ... the question not relevant because the size of redo
logs does not relate to the size of transactions.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Oct 16 2006 - 20:26:50 CDT
