Re: How to avoid waiting for locks during delete

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Thu, 14 Aug 2003 11:32:54 +0200
Message-ID: <bhfl07$h9g$1@news.fujitsu-siemens.com>

"Billy Verreynne" <vslabs_at_onwe.co.za> schrieb im Newsbeitrag news:1a75df45.0308140108.3ddc3f52_at_posting.google.com...
> "André Hartmann" <andrehartmann_at_hotmail.com> wrote
> If we can replace 10's or even 100's of GB in an Oracle table within
> _seconds_.. that tells me that you are doing something seriously wrong
> by locking GB's of data for days on end with a single transaction.
What about this:
You have two schemata, A and B. You import the data into B, start a transaction (so you get a consistent view of A), do all the complicated stuff
and when you're sure it has to go into A, you just put it in.

Lots of Greetings!
Volker Received on Thu Aug 14 2003 - 04:32:54 CDT