RE: Big Update on Busy Table
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 17 Jul 2014 20:56:35 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901E02F1E_at_exmbx05.thus.corp>
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Charlotte Hammond [dmarc-noreply_at_freelists.org] Sent: 17 July 2014 21:36
To: ORACLE-L
Subject: RE: Big Update on Busy Table
Date: Thu, 17 Jul 2014 20:56:35 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D901E02F1E_at_exmbx05.thus.corp>
I may have missed any comment you made about version - but if you're running 11.2 then it looks as if you need to check what the dbms_parallel_execute package could do for you: http://jonathanlewis.wordpress.com/2013/09/09/parallel-execution-2/
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of Charlotte Hammond [dmarc-noreply_at_freelists.org] Sent: 17 July 2014 21:36
To: ORACLE-L
Subject: RE: Big Update on Busy Table
Everyone - thanks for your suggestions!
No, unfortunately I can't get any downtime on this table. It's very busy 24x7 - running the update as a single statement would take well over an hour and lock many rows. The update is about 400 million rows of a 2 billion row table.
<UrlBlockedError.aspx>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 17 2014 - 22:56:35 CEST