Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Multi Threaded server not working for many inserts?

Re: Multi Threaded server not working for many inserts?

From: NetComrade <>
Date: Wed, 17 Mar 2004 16:57:43 GMT
Message-ID: <40587755.4122538967@localhost>

On 17 Mar 2004 04:43:26 -0800, (Billy Verreynne) wrote:

> (NetComrade) wrote :
>> This doesn't happen a lot, but seems to
>> happen plenty when the application control-c's the session (e.g. see
>> bug 2334868) or uabruptly disconnects.
>There is no bug listed on Metalink with that bug id.

I don't come up with this stuff:

The patch that fixes above bug was not applied in our live environment yet, therefore I can't say whether it fixed our problems.

I even found the other bug I was referring to earlier (60second hang):

Note, that the bugs were around since version 8, but were only fixed in 10g (first), or 9i release 2, which is why I say Oracle neglects MTS. There are of course 'backdoor' patches, or whatever they call them.

>> I think MTS is not that widely used, therefore it doesn't get enough
>> attention from Oracle. Things are complicated further on our site by
>> having to use db-links over MTS as well.
>Think again. MTS is *critical* for any Oracle server which services
>more than just a couple of users. I would think that using dedicated
>server is the exception - unless of course the majority is ignorant
>with head-up-ass approach thinking that dedicated server is scaleable
>enough in a corporate environments that deals with large numbers of

>Or where you have a small number of users and even a smaller server
>platform with limited memory - which also requires MTS as the only
>solution capable of enabling an Oracle server on such a small

Dedicated server is definetely more stable. MTS is also not good for transactions beyond a few secs. I think dedicated up to 1000 users is fine, provided you have enough memory and the users are not very active (every second).

Sometimes I am forced to switch to dedicated when MTS starts misbehaving, unfortunately that's not always an option.

>I have yet to run into any serious MTS specific bugs. And I'm using
>MTS on a number of different platforms and architectures (OLTP, OLAP,
>development, 3 tier app server, etc). And if MTS can work well in a
>dev environment (the most abusive Oracle environment you can get), it
>sure as hell will work well in others. IMO.

We use Oracle on Solaris 2.7 boxes remove NSPAM to email Received on Wed Mar 17 2004 - 10:57:43 CST

Original text of this message