Re: Multi Threaded server not working for many inserts?

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

>andreyNSPAM_at_bookexchange.net (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:
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=2334868.8

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):

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=BUG&p_id=1579203

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

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

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 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Wed Mar 17 2004 - 10:57:43 CST