Re: Operations in huge transaction slow down suddenly. Why?

Bernhard Graeuler wrote:

> Then we have to merge the existing data with te newly loaded data. In this
> step (roughly explained), new records were inserted in the existing tables.
> Information about newr- and changes on existing data were reported as
> conflicts into a separate table. These conflicts have to be resolved
> manually after the import finishes.
> This second step is running in one single transaction. Many thousands of
> records were inserted into the table containing the conflicts.

Use ana's response to work on the existing problem. But I wonder why you folks reinvented the wheel? The capability you seem to be describing is native to Oracle.

Go to http://www.psoug.org
click on Morgan's Library
click on DBMS_RECTIFIER_DIFF

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
   http://www.newsfeed.com       The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----