tag:blogger.com,1999:blog-12459003.post8174507830418864078..comments2023-08-03T09:19:28.438-04:00Comments on So What Co-operative: The final nail for shared serversJeff Hunterhttp://www.blogger.com/profile/15701602600662849251noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-12459003.post-43041788501540831042007-08-02T13:48:00.000-04:002007-08-02T13:48:00.000-04:00Very interesting!Very interesting!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12459003.post-58822281846234244312007-04-02T07:17:00.000-04:002007-04-02T07:17:00.000-04:00I have been using MTS on 9.2 on Solaris but I cann...I have been using MTS on 9.2 on Solaris but I cannot say I am pleased with it. It caused lots of problems for us, ORA-600s, ORA-7445s, issues with distributed transactions. We finally gave up using it.Yasin Baskanhttps://www.blogger.com/profile/07642821755164831104noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-51665659069662434182007-04-01T15:12:00.000-04:002007-04-01T15:12:00.000-04:00My only experience with MTS is throwing it out for...My only experience with MTS is throwing it out for performance reasons. I still feel vaguely ripped off for taking the course in the '90s. Even though it is one of the few courses I got someone else to pay for.Joel Garryhttps://www.blogger.com/profile/13325061229393838224noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-21306019990535545512007-04-01T12:21:00.000-04:002007-04-01T12:21:00.000-04:00If you have access to the book "Oracle Insights Ta...If you have access to the book "Oracle Insights Tales of Oak table", Dave Ensor has some 'nice' things to say about MTS in his chapter on Oracle history.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12459003.post-55194280078478721372007-03-30T21:13:00.000-04:002007-03-30T21:13:00.000-04:00People that advocate the usage of shared server ju...<I>People that advocate the usage of shared server just don't have adequate experience or know how much "balance out" the recommended best practices from oracle.</I><BR/>Oh, I don't know about that. I've been using MTS on Solaris since 7.2 and have only run into problems on Linux. Maybe my applications have changed in 15 years, maybe the MTS code has gotten a little loose in that time, but I'veJeff Hunterhttps://www.blogger.com/profile/15701602600662849251noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-11413656503295879492007-03-30T21:02:00.000-04:002007-03-30T21:02:00.000-04:00I have seen various issues with shared server goin...I have seen various issues with shared server going back to late 90's on hpux and solaris. No way these problems are confined to linux.<BR/><BR/>No way I would ever run them in my production environments. People that advocate the usage of shared server just don't have adequate experience or know how much "balance out" the recommended best practices from oracle.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12459003.post-56686114636882881362007-03-30T18:42:00.000-04:002007-03-30T18:42:00.000-04:00I guess these days most of the connection pooling ...<I>I guess these days most of the connection pooling in enterprise development can be controlled by the middle tier, making shared server a less obvious choice anyway.</I><BR/>agreed. But we still have a substantial base of cgi/mod_plsql scripts that connect to the database, do something, and disconnect. Maybe this will be the driver to move to Apex or something else...Jeff Hunterhttps://www.blogger.com/profile/15701602600662849251noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-78293200661153540892007-03-30T18:41:00.000-04:002007-03-30T18:41:00.000-04:00I can tell you that the majority of problems I've ...I can tell you that the majority of problems I've had with MTS has been on Linux. I've been running 8i and 9i on Solaris for years without any issues. Test, test, test, and consider using dedicated servers.Jeff Hunterhttps://www.blogger.com/profile/15701602600662849251noreply@blogger.comtag:blogger.com,1999:blog-12459003.post-4065862704742762802007-03-30T12:22:00.000-04:002007-03-30T12:22:00.000-04:00I've been running shared servers/MTS for about 5 y...I've been running shared servers/MTS for about 5 years now, on Oracle8i and now Oracle9i, on Solaris. We ran it because the vendor providing our primary application specified it that way. I'm going to be changing to a Linux server in the next few months, should I be concerned? Have I just been lucky?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12459003.post-90289251914429858202007-03-30T11:18:00.000-04:002007-03-30T11:18:00.000-04:00I've never been convinced about shared server, or ...I've never been convinced about shared server, or MTS as it was known. It seems every release claims to fix the bugs in it, but you still get lots of people griping about it.<BR/><BR/>I guess these days most of the connection pooling in enterprise development can be controlled by the middle tier, making shared server a less obvious choice anyway.<BR/><BR/>Did I just advocate offloading Tim...https://www.blogger.com/profile/17721555946005999179noreply@blogger.com