Re: Oracle Multi-Threaded Server

From: <andreas.prusch_at_sintec.de>
Date: Fri, 22 May 1998 06:31:41 GMT
Message-ID: <6k364e$j5q$1@nnrp1.dejanews.com>

We're using MTS with Sun Solaris 2.x. Generally we have no problem. There's a little overhead in the response time of fast little queries. But if you have many users the difference between the response times is going to 0. An interesting thing is to use MTS with Data Warehouse Applications. You can give a lot of MB sort memory to the servers. Because you can limit the servers you avoid the "out of memory" of many inactive users with al lot of sort space.

In article <6k1495$q2q$1_at_nnrp1.dejanews.com>, yossiz_at_amdocs.com wrote:
>
> Does any one have experience with Multi-Threaded Server of Oracle 7.3 or
> Oracle 8 on AIX?
>
> Any known problems?
>
> What are the overheads of this configuration?
>
> Thanks in advance.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 22 1998 - 01:31:41 CDT