Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: most expeditious way to update a large number of rows
DA Morgan wrote:
> 671K rows is NOT a large number. Perform the update then commit. What
> you have done is an invitation for a visit from ORA-01555 and very
> inefficient.
>
> If it is taking you 74 hours to perform the update archive logging is
> not your issue. Explain Plan with DBMS_XPLAN should be the next thing
> you do.
> --
> 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
Thanks, Daniel. I have five redo logs, each 10MB in size. Do you think this will suffice? I'm not concerned with the standby database. I'll let FAL handle that. Received on Mon Oct 16 2006 - 10:54:31 CDT