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?
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
![]() |
![]() |