Re: wanted: Oracle8i MTS experiences/successes/war stories

From: Ban Spam <ban-spam_at_operamail.com>
Date: Fri, 19 Oct 2001 00:49:44 GMT
Message-ID: <Xns913EB5657F3BESunnySD@24.0.3.73>

"Spencer" <spencerp_at_swbell.net> wrote in news:Txrz7.451$Ol3.274357337 @newssvr11.news.prodigy.com:

> Everyone,
>
> Thanks in advance for any information or insight you can provide.
>
> The company I work for is currently assessing the viability of the
> multithreaded server (MTS) feature of Oracle8i. (Specifically,
> Oracle Enterprise Server 8.1.7.2.0 for Sun sparc Solaris 5.7)

Tom Kyte's book warns against using MTS where there will be "long running transactions".

I had a system where nightly batch jobs were being run into an instance via MTS. These jobs took 4 - 6 hours to complete. Once I brought the same jobs into the same system via DEDICATED connections the run times dropped to just under 60 minutes! Received on Thu Oct 18 2001 - 19:49:44 CDT