Multi Threaded server not working for many inserts?

Hi,

Sorry for the cross-posting but I am not sure which newsgroup to use. We have the following configuration
Oracle 8.1.7.3.0 running on VMS, 2 database-instances and on both instances Multi Threaded Server is configured.

There is a databaselink defined from instance B to instance A and we defined a synonym for tableA in instance B
We log-on to instance B.

Now we want to do the following (from SQLPLUS).

insert into tableA (on instance A) select field1, field2, field3 from tableB (on instance B)

It looks that when the select only returns 1 row the insert into the other instance works.
But when the selects returns more rows the insert will hang. No error is reported back from Oracle.

The only thing we can do is let our DBA 'kill' the underlying proces.

Are there any known bugs and workarounds in Multi Threaded Server configurations which indicate problems with large inserts????

Please help (google didn't give me any answers) Roy Received on Fri Mar 12 2004 - 05:00:40 CST