Re: Migration from Oracle 7.3.4 to 8.17

From: Ban Spam <ban-spam_at_operamail.com>
Date: Mon, 30 Jul 2001 01:34:16 GMT
Message-ID: <Xns90EDBCEA61E01SunnySD@24.0.3.73>

"Thomas Kindermann" <TKINDERMANN_at_TYCOINT.COM> wrote in news:3b5fc41e$0$91631$45beb828_at_newscene.com:

> Hi,

[...snip...]
> We have a 80% OLTP and 20% batch-system
> Whats about multithreaded server ?

Multi-Threaded Server trades memory for response time. MTS allows you to conserver or reduce the memory consumption by Oracle but at the expense of response time.

I just got done getting rid of MTS because when coming into the DB via a dedicated connection (vs. MTS) the batch run times went from 4 - 6 HOURS to under 1 hour.

HTH & YMMV! Received on Sun Jul 29 2001 - 20:34:16 CDT