Multi Threaded server not working for many inserts?
Date: Fri, 12 Mar 2004 12:00:40 +0100
Message-ID: <c2s5do$m2m$1_at_azure.qinip.net>
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
Now we want to do the following (from SQLPLUS).
insert into tableA (on instance A) select field1, field2, field3 from tableB
(on instance B)
We log-on to instance B.
It looks that when the select only returns 1 row the insert into the other
instance works.
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????
But when the selects returns more rows the insert will hang. No error is
reported back from Oracle.
Please help (google didn't give me any answers) Roy Received on Fri Mar 12 2004 - 12:00:40 CET