"Preparing & Executing Massive DML Operations e.g. updates."
From: fmh <fmhabash_at_gmail.com>
Date: Mon, 19 Aug 2013 11:18:19 -0400
Message-ID: <CADpeV5zrQDaT2voO2rW12SQG5ibu+Qmu0K_MWRZ18Dsv1wQ_og_at_mail.gmail.com>
I usually prepare for such ops ...
- Instance prep: disable archive logs, use no logging ,... etc.
Date: Mon, 19 Aug 2013 11:18:19 -0400
Message-ID: <CADpeV5zrQDaT2voO2rW12SQG5ibu+Qmu0K_MWRZ18Dsv1wQ_og_at_mail.gmail.com>
I usually prepare for such ops ...
- Instance prep: disable archive logs, use no logging ,... etc.
- Session prep: enable PQ, PDML, ...etc
- SQL Prep: rewrite it e.g. updateble inline views vs. correlated queries.
- Use BULK SQL if need to.
I'm running an update on a partitioned table of 44M rows. It has been 3
days now and there seems end is not near.
- The update session is the only FG session in the db. v$session_longops show the query involved but all rows have 'sofar=totalwork'. The view has not updated since 2 days ago. How else can progress be monitored?
- I did enable PDML ,but on 10.2.0.3, we hit this bug. The workaround did not work to disable the recycle bin. This was a major set back. Bug 4896424
- Parallel DML can fail with ORA-60 (Doc ID 4896424.8)
If you've had any experience with such operations, please provide your comments/feedback to the above inquiries.
-- ---------------------------------------- Thank you -- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 19 2013 - 17:18:19 CEST