Re: Bad performance with MTS

From: <andreas.prusch_at_sintec.de>
Date: Fri, 12 Jun 1998 08:25:43 GMT
Message-ID: <6lqom7$cid$1@nnrp1.dejanews.com>

Check your shared pool size. It must be great enough to hold the memory for the shared servers (PGA, session information, sort area, response and request queue), only stack will be allocated out of SGA. Start initially enough dispatcher! and shared server. Don't set the upper bound for shared servers to low (mts_max_servers). Let the instance connect via ipc to the listener (mts_listener_address). We use Oracle 7.3.2 and SOLARIS 2.5 with MTS. Response time on little queries is a little but not significant slower. On larger queries it is not really meaningful.

Hope this will help,
Andreas Prusch

In article <6lld8a$fbr$1_at_news01.btx.dtag.de>, jkurzend_at_t-online.de (Joerg Kurzendoerfer) wrote:
>
> HELP !
>
> We have runnig Oracle 7.3.2.3 under HP-UX 10.20.
> We would like to use MTS. But performance is very bad.
> Compared to the dedicated server mode, response time is
> about 4-5 times higher with MTS.
> An Oracle guy told me "that's normal with MTS".
> But I still suppose it's a bug inside Oracle and/or HP-UX.
> Could anybody help me?
>
> Regards
>
> Joerg Kurzendoerfer
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Jun 12 1998 - 03:25:43 CDT