Re: Multi Threaded server not working for many inserts?

"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:1a75df45.0403161049.201206fb_at_posting.google.com...
> "Royco" <bla_at_bla.nl> wrote
>
> <snipped>
> > Are there any known bugs and workarounds in Multi Threaded Server
> > configurations which indicate problems with large inserts????
>
> This posting reminds me of a young scientist who caught a fly. He
> placed the fly on the lab table. He clapped his hands. The fly flew
> away. "Hearing. Excellent!" he wrote. He caught the fly again. Torn
> the fly's wings off and placed it on the table. He clapped his hands.
> The fly did not move. So he wrote in his lab notes "A fly without
> wings looses its ability to hear! Amazing!!".
>
> I.e. blaming your problems on MTS without providing a single shred of
> evidence or offering any kind of analysis results does not cut it.
>
Well ...thanks for you help.

For your information : A software company who sold us an Oracle based application advised us against using MTS because of the strange behaviour. We made our servers (8i on VMS) dedicated. At this moment however we are 'forced' to use Multi Threaded Server because some components under w2k are transactional AND uses databaselinks. (or else ORA 24777: Use of Non-migratable database link not allowed). We did investigate and our DBA is at a loss. Traces don't work en 'killing' some database-processen is the only way (apart from a restart) to make the instances responsive again.

Furher 'investigation' made us find out that a 'pull' mechanisme works fine. So
insert into tableA_at_instanceA select field1, field2, field3 from tableB_at_instanceB

when we log-on to instanceA (pull) works fine (...uh...we haven't had the Oracle instances hanging YET)

but when we log-on to InstanceB (so we push data to instance A) we still have the hanging problem (to be more exact: 1 row works)

roy Received on Wed Mar 17 2004 - 07:33:11 CET