<p>we're dealing with a very slow update statement in an Oracle project.</p>

<p>Here's a little script to replciate the issue:</p>

<pre><code>drop table j_test;

CREATE TABLE J_TEST
(
  ID  NUMBER(10) PRIMARY KEY,
  C1   VARCHAR2(50 BYTE),
  C2   VARCHAR2(250 BYTE),
  C3   NUMBER(5),
  C4   NUMBER(10)
);

-- just insert a bunch of rows
insert into j_test (id)
select rownum 
from &lt;dummy_table&gt;
where rownum &lt; 100000;

-- this is the statement that runs forever (longer than my patience allows)
update j_test
set C3 = 1,
    C1 = 'NEU';    
</code></pre>

<p>There are some environments where the Update-Statement takes just about 20 seconds, some where the statement runs for a few minutes. When using more rows, the problem gets even worse.</p>

<p>We have no idea what is causing this behavior, and would like to have an understanding of what is going on before proposing a solution.</p>

<p>Any ideas and suggestions?
Thanks
Thorsten</p>

Try this:
```
```
insert into j_test (id, C3, C4)
select rownum, 1, 'NEU'
from <dummy_table>
where rownum < 100000;
```
```