Re: Multi Threaded server not working for many inserts?

[Yosua]

This response seems ego driven
"Billy Verreynne" <vs****@onwe.co.zawrote in message
news:1a**************************@posting.google.c om...

"Royco" <bl*@bla.nlwrote

<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.

Processes do not hang. They do not get stuck at a machince code
instruction and "hang" at that instuction.

So even if it appears the car does not seem to be moving, the engine
is still running. So you need to roll up your sleeves, pop the hood,
and see what is happening inside. Is the car in gear? Is the car not
maybe upside down? Did someone replace the fan with a Cessna 152 prop
in an attempt to turn it into a plane?

And yeah, this analogy is very apt when it comes to how some people
insist on using Oracle.

I.e. what does the wait events for that process say? What does the
rows gotten, i/o reads/writes and other session stats say for that
process? Have you enabled SQL tracing for that session when it appears
to be hung? Have you had a look at operating system wait events?

Or is this kneejerk re-action that MTS must be to blame typical of the
investigative and troubleshooting skills of today's IT/Oracle
professional?

And yes dammit, I can do with anther mug of coffee. Or two...

--
Billy